Postgre describe table

Describe table postgres

postgres=# \d schema.tablename;

Source: postgresqltutorial.com

Show details of table postgres

postgres=# \d tablename;

Postgre describe table

        
            
        
     SELECT 
   table_name, 
   column_name, 
   data_type 
FROM 
   information_schema.columns
WHERE 
   table_name = 'city';

Source: postgresqltutorial.com

Similar codes

8 votes118 views3 answers
Alter table auto_increment
SQL
3 votes165 views1 answer
Query less than datetime sql
SQL
2 votes122 views3 answers
How to pass password mysql command line
SQL
0 vote129 views1 answer
Laravel eloquent get generated sql
SQL
0 vote132 views1 answer
Reset postgresql password windows
SQL
3 votes122 views4 answers
Ubuntu stop mysql
SQL
2 votes139 views3 answers
Oracle show column of table
SQL
0 vote108 views1 answer
Login phpmyadmin without password
SQL
0 vote133 views1 answer
Query only first letter string
SQL
4 votes130 views1 answer
Refresh postgres config
SQL