Create database schema document: Difference between revisions
Jump to navigation
Jump to search
→PostgreSQL: Table document (Schema)
No edit summary |
|||
| Line 63: | Line 63: | ||
WHERE | WHERE | ||
a.table_name = '<MY_TABLE>'; | a.table_name = '<MY_TABLE>'; | ||
</pre> | |||
== 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] | |||
<pre> | |||
pg_dump -st <MY_TABLE> <MY_DATABASE> --schema-only > schema.sql | |||
</pre> | </pre> | ||