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 vote241 views1 answer
Query params sql insert python f string
SQL
0 vote237 views1 answer
Sql convert float to string
SQL
0 vote250 views1 answer
Nodejs sql get one to many relationship as array
SQL
0 vote234 views3 answers
Sql delete all except
SQL
0 vote259 views1 answer
Sql: extract day text from datetime value
SQL
0 vote192 views1 answer
Oracle sql developer script output limit
SQL
0 vote278 views2 answers
Sql query print strings and int
SQL
0 vote291 views1 answer
Intellij mysql set timezone
SQL
4 votes252 views1 answer
Postgresql list sequences
SQL
0 vote240 views1 answer
Running query in redshift
SQL