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 vote214 views1 answer
Count database access django
SQL
0 vote236 views1 answer
Select year from dual oracle
SQL
32 votes196 views6 answers
Insert into values select
SQL
0 vote181 views1 answer
Backup a table in sql
SQL
4 votes213 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote200 views2 answers
How to get the date from datetime in mysql
SQL
0 vote201 views1 answer
Mac os zsh: command not found: mysql
SQL
4 votes200 views4 answers
Rollback in sql
SQL
0 vote189 views1 answer
Database get 10 user aleatory
SQL
4 votes200 views1 answer
Refresh postgres config
SQL