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, Dec 20 '17 at 12:30
Possible duplicate of [Postgres Dynamic Query Function](https://stackoverflow.com/questions/10639963/postgres-dynamic-query-function) — Gholamali Irani, Dec 20 '17 at 12:58
It was only a curiosity. Today it's my first day in sql. Thanx — ilFonta, Dec 20 '17 at 12:59
Duplicate of https://stackoverflow.com/questions/45742536/wildcard-select-of-columns — faintsignal, Oct 23 '19 at 16:19

score 1 · Answer 1 · answered Jul 08 '21 at 11:50

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 08 '21 at 11:50

Rui Costa

1 Answers1