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

1 vote263 views1 answer
Concat first name and last name in mysql
SQL
1 vote222 views1 answer
Mysql monthname
SQL
3 votes245 views2 answers
Wp do sql query from function
SQL
0 vote231 views1 answer
How to execute stored output to csv files
SQL
1 vote220 views1 answer
Sql server reseed single table
SQL
0 vote267 views3 answers
Postgres trim string
SQL
0 vote223 views1 answer
Mysql show category once count how many products
SQL
0 vote212 views1 answer
Bash block size ls /var/lib/mysql
SQL
40 votes221 views6 answers
Update table mysql
SQL
0 vote225 views1 answer
Add alternate add column sql
SQL