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

0 vote149 views2 answers
Mysql output csv
SQL
0 vote176 views1 answer
Connecting mySQL to STS
SQL
0 vote151 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote166 views1 answer
How to see the query of a view in mysql
SQL
0 vote150 views1 answer
Close sql query vb.net
SQL
0 vote149 views1 answer
How to get n result in sql
SQL
3 votes181 views1 answer
Unsigned int in mysql
SQL
1 vote166 views1 answer
Query for all indexes in table postgres
SQL
1 vote170 views1 answer
Postgresql filter on
SQL
0 vote162 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL