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

3 votes220 views1 answer
APEX elapsed time
SQL
1 vote206 views1 answer
Calculate age in sql postgresql
SQL
13 votes206 views2 answers
Sql count distinct group by
SQL
1 vote199 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
1 vote206 views1 answer
Python escape mysql
SQL
16 votes206 views2 answers
Add column to all tables after first column mysql
SQL
0 vote266 views1 answer
Php insert null mysql
SQL
0 vote194 views1 answer
Pl sql search saurce code
SQL
0 vote164 views0 answer
SQL
1 vote201 views2 answers
Sql left characters
SQL