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 vote139 views1 answer
Low level operator in dbms
SQL
1 vote142 views1 answer
What is a Database?
SQL
3 votes172 views2 answers
Enter mysql command line
SQL
0 vote147 views1 answer
Proc sql not in working
SQL
10 votes142 views4 answers
Primary key sql
SQL
0 vote149 views1 answer
How to get first 10 records of a table in mysql
SQL
1 vote174 views1 answer
Mysql default port
SQL
0 vote137 views1 answer
What is between operator
SQL
0 vote132 views1 answer
Find largest table in mysql database
SQL
1 vote143 views1 answer
Sql string function update replace
SQL