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 vote126 views1 answer
Declaring variables in pl sql
SQL
0 vote100 views1 answer
Oracle list index on table
SQL
0 vote111 views1 answer
MySQL - How to find word with the most similar beginning
SQL
1 vote96 views1 answer
Sql select contem uma palavra
SQL
0 vote97 views1 answer
Uninstall mysql ubuntu 18.04 stackoverflow
SQL
0 vote104 views1 answer
Connexion mysql
SQL
0 vote110 views1 answer
Provide hardcoded value in the mysql query
SQL
2 votes113 views2 answers
How to run postgresql in linux
SQL
0 vote102 views1 answer
Mariadb used space
SQL
0 vote105 views2 answers
Default constraint in ms sql
SQL