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

16 votes342 views3 answers
Order by sql query
SQL
1 vote359 views1 answer
How to install mysql 8.0 windows service
SQL
1 vote349 views1 answer
Ef core 5.0 usesqlserver not found
SQL
2 votes361 views1 answer
Scaffold npgsql net core
SQL
1 vote420 views1 answer
Opensuse restart MySQL
SQL
1 vote359 views1 answer
Mariadb alter user host
SQL
0 vote354 views1 answer
Drop procedure sql
SQL
1 vote348 views1 answer
Sample clause in sql
SQL
0 vote346 views1 answer
Sql query interview questions githu
SQL
0 vote340 views1 answer
Mod function example
SQL