Accessing PostgreSQL Fields via Indexing

Question

Is there a way in PostgreSQL to access fields without explicitly providing the column name? For example, instead of the statement:

select (col1,col2,col3,...col42) from foo_table;

there's a (possible) alternative of:

select (1:42) from foo_table;

No, not possible. But this seems like a strange requirement and actually might indicate a bad (de-normalized) data model and the columns should actually be rows — user330315
– user330315, Commented Feb 10, 2020 at 17:42

Mureinik · Accepted Answer · 2020-02-10 17:48:51Z

1

There is no such syntax in Postgres' SQL.

You could always resort to having code that dynamically constructs the query for you before executing it, but that's about as good as it will get.

answered Feb 10, 2020 at 17:48

Mureinik

316k54 gold badges399 silver badges405 bronze badges

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

1 Answer 1