Postgres grant create db permission« an older post
a newer one »Postgres dump all but one table

Postgres SHOW CREATE TABLE equivalent

Snippet Written with a loving hand by kitt some time around 14:00 on 30 December 2019

Sometimes, you want to create a table outside of a database dump import. MySQL has "SHOW CREATE TABLE" and Postgres does not.

However, close enough.

# just the table create command
pg_dump --schema-only --table TABLENAME DATABASE_URL
 
# include all the indices and alter tables and such
pg_dump -st tablename dbname
Source: 
https://serverfault.com/questions/231952/is-there-an-equivalent-of-mysqls-show-c…
#postgres

Add new comment

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.