How to generate the “create table” sql statement for an existing table in postgreSQL

by 
pg_dump -t 'schema-name.table-name' --schema-only database-name

More info – in the manual.

More Related Contents:

  1. How to reset postgres’ primary key sequence when it falls out of sync?
  2. How to import CSV file data into a PostgreSQL table
  3. Calculating and saving space in PostgreSQL
  4. The forgotten assignment operator “=” and the commonplace “:=”
  5. Equivalent to unpivot() in PostgreSQL
  6. Passing user id to PostgreSQL triggers
  7. PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
  8. I forgot the password I entered during postgres installation
  9. Do nullable columns occupy additional space in PostgreSQL?
  10. PostgreSQL: serial vs identity
  11. Postgres password authentication fails
  12. Generate series of dates – using date type as input
  13. Copy a few of the columns of a csv file into a table
  14. Postgres query to check a string is a number
  15. Using pyspark to connect to PostgreSQL
  16. Returning from a function with OUT parameter
  17. ERROR: permission denied for relation tablename on Postgres while trying a SELECT as a readonly user
  18. How do you create a random string that’s suitable for a session ID in PostgreSQL?
  19. PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement
  20. Update timestamp when row is updated in PostgreSQL
  21. Postgresql query array of objects in JSONB field
  22. How to add a conditional unique index on PostgreSQL
  23. Heroku database restore issue
  24. user postgres launches process that takes all CPUs 100% usage
  25. PostgreSQL disable more output
  26. PostgreSQL array_agg order
  27. Postgres table column name restrictions?
  28. How do I get min, median and max from my query in postgresql?
  29. PostgreSQL jsonb, `?` and JDBC
  30. Syntax error at end of input in PostgreSQL

Leave a Comment