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

6 votes203 views2 answers
Postgresql pg_dump
SQL
11 votes242 views2 answers
Docker create postgres db
SQL
0 vote213 views1 answer
Redshift running queries
SQL
0 vote254 views1 answer
Osm2pgsql mac
SQL
0 vote179 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote178 views1 answer
Oracle sql procedure return value
SQL
5 votes266 views4 answers
Restart the psql server windows
SQL
0 vote189 views3 answers
Between keyword sql
SQL
0 vote148 views1 answer
Como leer datos de mysql esp32
SQL
0 vote177 views1 answer
Rows, INSERT INTO, Returning with alias
SQL