TECHIES WORLD

For Techs.... Techniques.... Technologies....

BashCpanelLinux

How to describe table in PostgreSQL

We can use '\d' query to describe table in PostgreSQL.

>\d schemaname.tablename ;

Here schemaname and tablename needs to be replaced accordingly.

If need more information, use '\d+' command.

>\d+ schemaname.tablename ;

Here schemaname and tablename needs to be replaced accordingly.

That's all….

Leave a Reply