Create database schema document: Difference between revisions
Jump to navigation
Jump to search
m
→PostgreSQL: DDL document
| (4 intermediate revisions by the same user not shown) | |||
| 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 | ||
</pre> | </pre> | ||
{{exclaim}} The parameter {{kbd | key=<nowiki><MY_TABLE></nowiki>}} is before than another parameter {{kbd | key=<nowiki><MY_DATABASE></nowiki>}} | |||
== References == | == References == | ||
| Line 80: | Line 83: | ||
[[Category:MySQL]] | [[Category:MySQL]] | ||
[[Category:Database]] | |||
[[Category:PostgreSQL]] | |||
[[Category:Data Science]] | [[Category:Data Science]] | ||