Create database schema document: Difference between revisions
Jump to navigation
Jump to search
→PostgreSQL: DDL document
No edit summary |
|||
| Line 67: | Line 67: | ||
== PostgreSQL: DDL document == | == PostgreSQL: DDL document == | ||
[https://serverfault.com/questions/231952/is-there-an-equivalent-of-mysqls-show-create-table-in-postgres postgresql - Is there an equivalent of MySQL's SHOW CREATE TABLE in Postgres? - Server Fault] | [https://www.postgresql.org/docs/current/app-pgdump.html PostgreSQL: Documentation: 14: pg_dump]<ref>[https://serverfault.com/questions/231952/is-there-an-equivalent-of-mysqls-show-create-table-in-postgres postgresql - Is there an equivalent of MySQL's SHOW CREATE TABLE in Postgres? - Server Fault]</ref> | ||
<pre> | <pre> | ||
pg_dump -st <MY_TABLE> <MY_DATABASE> --schema-only > schema.sql | pg_dump -st <MY_TABLE> <MY_DATABASE> --schema-only > schema.sql | ||