25 нояб. 2013 г. · SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'table_name'; with the above query you can retrieve columns and its datatype.

3 сент. 2014 г. · SHOW TABLES and DESCRIBE TABLE are MySQL-specific admin commands, and nothing to do with standard SQL. You want the: \d. and \d+ tablename.

4 февр. 2010 г. · I would like to get the columns that an index is on in PostgreSQL. In MySQL you can use SHOW INDEXES FOR table and look at the Column_name column.

21 авг. 2018 г. · All of the tables have two columns, one of them always being a column name called time . Using the UNION method does not return 19 time strings.

12 июн. 2017 г. · Use col_description() on pg_attribute: select attname as column_name, atttypid::regtype as data_type, col_description(attrelid, attnum) as description.

28 янв. 2020 г. · You can use: SELECT * FROM information_schema.columns WHERE table_name = 'your_table' ORDER BY column_name DESC;. As the documentation says:.

29 авг. 2013 г. · I'm using PostgreSQL 9.1. I have the column name of a table. Is it possible to find the table(s) that has/have this column? If so, how?

14 апр. 2011 г. · In psql you can simply use the \d+ command to show all tables including their comments. Or use the \dd command to show all comments in the system.

20 сент. 2019 г. · A quick hack would be to just: SELECT * FROM public.view_name LIMIT 0; Depending on your client, column names and types should still be displayed.

24 мар. 2016 г. · The psql CLI for PostgreSQL has a meta-commands \d that shows columns for all "relations" (table, view, index, sequence, or foreign table) and a meta-command \ ...