Skip to content

create view from a table with many columns in postgresql

James Phelps edited this page Mar 1, 2019 · 1 revision

Follow the instructions from this blog

Then select the column names SELECT column_name FROM information_schema.columns WHERE table_schema = 'your_schema' AND table_name = 'your_table'

That's it

Clone this wiki locally