Psql show columns of table

Show details of table postgres

postgres=# \d tablename;

Psql show columns of table

SELECT 
   table_name, 
   column_name, 
   data_type 
FROM 
   information_schema.columns
WHERE 
   table_name = 'city';Code language: SQL (Structured Query Language) (sql)

Source: postgresqltutorial.com

Postgre describe table

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

Source: postgresqltutorial.com

Similar codes

0 vote119 views1 answer
Mariadb mysql root access denied
SQL
0 vote119 views1 answer
How to close external sql connection in laravel
SQL
0 vote168 views1 answer
Selecting from a view SQL
SQL
0 vote141 views1 answer
Sql_inner_join
SQL
0 vote111 views1 answer
Mssql current date
SQL
0 vote132 views1 answer
Sql cmd no truncate
SQL
-1 vote112 views1 answer
Sql getdate date only
SQL
4 votes110 views1 answer
Sql group by year
SQL
0 vote126 views1 answer
Mysql make date from 2 column
SQL
0 vote133 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL