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 Related posts: MySQL InnoDB File Per Table MySQL Error: Column count of mysql.proc is wrong. Expected 20, found 16. The table is probably corrupted; Fix Plesk DBWebAdmin table copy problem Convert MyISAM Tables to InnoDB Change Minimum Word Length In Fulltext Search
