Postgre describe table

Describe table postgres

postgres=# \d schema.tablename;

Source: postgresqltutorial.com

Show details of table postgres

postgres=# \d tablename;

Postgre describe table

        
            
        
     SELECT 
   table_name, 
   column_name, 
   data_type 
FROM 
   information_schema.columns
WHERE 
   table_name = 'city';

Source: postgresqltutorial.com

Similar codes

1 vote257 views2 answers
How to check if sql query is correct online
SQL
0 vote242 views1 answer
Postgresql regular expression special characters
SQL
0 vote244 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote229 views1 answer
Mysql create table columns with spaces
SQL
0 vote269 views1 answer
Hoq to import database source
SQL
0 vote237 views1 answer
How to to get current date and time in sql
SQL
0 vote256 views3 answers
Create and attach user to a postgresql database
SQL
36 votes324 views6 answers
Change column data type sql
SQL
0 vote256 views2 answers
Select columns from 2 tables with foreign key
SQL
1 vote251 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL