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 vote240 views2 answers
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.
SQL
1 vote184 views1 answer
Oracle duration between timestamps
SQL
0 vote202 views1 answer
Executescalar in sql server
SQL
0 vote241 views2 answers
Uninstall postgresql mac
SQL
6 votes185 views2 answers
Where clause in sql
SQL
0 vote177 views1 answer
T-sql email validation
SQL
1 vote186 views1 answer
Postgresql escape single quote
SQL
1 vote223 views1 answer
Count of tables in database mysql
SQL
0 vote181 views1 answer
Mysql update privileges
SQL
1 vote201 views1 answer
Delete dublicate rows sql
SQL