Question
How to generate ddl for a table?

Answers

Use pg_dump utility to generate DDL.
Example:
pg_dump -t njonna.accounts -s -f ddl_accounts.sql
Where:

-f ddl_accounts.sql is output file.
-t njonna.accounts is table name with schema njonna.
-s dump only schema no data   Your Comment






Search
Can you Answer!!
  • Q In what film did the character Regan McNeil appear
  • Q Did you ever have a situation "go bad"? What did you do/how did your preceptor intervene?
  • Q How many number of sessions can one group in batches?
  • Q What are the services provided by Citrix?
  • Q Explain about ā€œsā€ permission bit in a file?
  • Q What are the steps to be taken in the case of emergency during flying?
  • Q What is extends ?
  • Q What is the currency of Egypt
  • Q Define monadic and dyadic functions, give examples?
  • Q What are the different ways of doing black box testing?
  • Q Why are females more likely to contract bladder infections than males?