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 vote275 views1 answer
SQLite order random
SQL
3 votes312 views6 answers
DB::table('users')->get();
SQL
0 vote292 views1 answer
Migration graphql
SQL
1 vote273 views1 answer
Mysql check table exists
SQL
0 vote273 views1 answer
Foreign key multiple columns
SQL
0 vote291 views1 answer
Oracle show grants on table
SQL
1 vote291 views1 answer
Sql first day quarter
SQL
7 votes325 views3 answers
Sql server check if temp table exists
SQL
0 vote279 views1 answer
Null column as zero in mysql
SQL
0 vote265 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL