PostgreSQL DESCRIBE TABLE Equivalent By admin on November 13, 2017 in PostgreSQL In MySQL I always use “DESCRIBE TABLE” or “SHOW CREATE TABLE” to show the schema of a table but I always forget how to do this in PostgreSQL. The PostgreSQL equivalent is: \d+ tablename 1 \d+ tablename 0