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

16 votes276 views1 answer
Mysql smallint range
SQL
11 votes269 views5 answers
How to install sqlite3 python
SQL
10 votes266 views3 answers
Sql check double value
SQL
0 vote251 views1 answer
Mysql trim characters
SQL
0 vote259 views1 answer
Android sqlite get rows count
SQL
10 votes292 views4 answers
SELECT FROM WHERE
SQL
0 vote287 views2 answers
Postgresql variable in query
SQL
0 vote262 views2 answers
Sql join on comma separated field
SQL
2 votes272 views1 answer
How to get non distinct values in sql
SQL
0 vote251 views1 answer
Mysql update sequence with order by
SQL