How to execute select row(*) in postgres

Question

In postgres you can return a row as a single cell as in the following:

select row(date_created,created_By)
from some_table

However this does not work when you execute select row(*)

Does anybody know how to implement the row() function using asterisk so if my table changes in the future, I will not have to modify my query?

I am using Postgres version 8.4.1

Thank you.

Why don't you just use select *? What is the real problem you are trying to solve here? Also: Postgres 8.4 is no longer maintained, you should really plan an upgrade to a supported version as soon as possible (at least use the latest minor version which is 8.4.22) — user330315
– user330315, Commented May 2, 2016 at 17:32

Vamsi Prabhala · Accepted Answer · 2016-05-02 17:21:39Z

3

You just need to prefix the * with the table-name or table-alias.

select row(s.*)
from some_table s

answered May 2, 2016 at 17:21

Vamsi Prabhala

49.4k4 gold badges41 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Genius! Thank you.