select multiple columns in PostgreSQL using wildcard characters

Question

It is possible to substitute a statement like this

select column1,column2,column3

with something like

select like 'column_'

in a Postgresql query?

It can be done using dynamic SQL. But why? Seems like an odd design decision to depend on column names. — jarlh
– jarlh, Commented Dec 20, 2017 at 12:30
It was only a curiosity. Today it's my first day in sql. Thanx — ilFonta
– ilFonta, Commented Dec 20, 2017 at 12:59

Rui Costa · Accepted Answer · 2021-07-08 11:50:49Z

1

No, you cannot use LIKE in the SELECT part of the query.

Wildcards can only be used in the WHERE part of the query.

answered Jul 8, 2021 at 11:50

Rui Costa

4472 silver badges11 bronze badges

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

1 Answer 1