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

3 votes331 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote341 views2 answers
Sql max count
SQL
0 vote353 views1 answer
Mysql select smaller of two values
SQL
0 vote337 views1 answer
Components/Fields of Internal Table
SQL
0 vote349 views2 answers
Athena drop partition
SQL
104 votes559 views2 answers
Like in mysql
SQL
0 vote359 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
1 vote294 views1 answer
Postgres reset auto increment
SQL
0 vote373 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
2 votes352 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL