13 авг. 2012 г. · SELECT * FROM information_schema.columns WHERE table_schema = 'your_schema' AND table_name = 'your_table' ;.

26 авг. 2014 г. · To get the same list of column names and types from a query, you could use a simple trick: CREATE a temporary table from the query output, then use the same ...

1 мая 2023 г. · I want to query the exact same order of this columns and their datatype, in order to make sure, what are the column names and what is the real column order.

3 нояб. 2020 г. · I want to get meta information of a view in postgres. Specifically the column data types. Any suggestion for how to do that?

20 янв. 2014 г. · Generally, use the information_schema: SELECT column_name FROM information_schema.columns WHERE table_schema = 'public' AND table_name = 'blah' ORDER BY column ...

21 мар. 2020 г. · You can create a temporary view, which registers the row type. Then query either the information schema like you tried or the system catalog pg_attribute.

17 мая 2018 г. · How to select all the columns whose names begins with "img" from a PostgreSQL table? I wrote that, but doesn't work select 'img%' from mytable.

24 сент. 2019 г. · PostgreSQL tracks on which table columns (and other objects) a view depends: Each view is related to its query rewrite rule in pg_rewrite.

11 мая 2020 г. · I have used the following to just view the column names of a table (without any values) Is there a way to view all column names in one column ...

14 авг. 2018 г. · In the psql command line this information is in the table sheet, obtained with the \d+ command. d+ also informs on the NOT NULL constraints.