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 vote116 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote117 views1 answer
Oracle get running queries
SQL
0 vote107 views1 answer
Hive batch drop table
SQL
0 vote122 views1 answer
Oracle call a function in a insert statement
SQL
4 votes106 views1 answer
Postgresql show current database
SQL
17 votes110 views6 answers
Sql current date
SQL
0 vote111 views1 answer
Grouping by email domain mysql
SQL
2 votes110 views1 answer
Select from array in psql
SQL
0 vote101 views1 answer
Order by monthly in sql
SQL
0 vote121 views1 answer
Value of sold product using having and group by in sql
SQL