Answers for "describe in postgres"

SQL
1

postgres describe query

select column_name, data_type, character_maximum_length, column_default, is_nullable
from INFORMATION_SCHEMA.COLUMNS where table_name = '<name of table>';
Posted by: Guest on June-25-2021
3

describe table postgres

postgres=# \d schema.tablename;
Posted by: Guest on June-24-2020
3

show details of table postgres

postgres=# \d tablename;
Posted by: Guest on July-15-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language