Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Posts
    80

    Unanswered: What tool can I use to generate DDL

    Given that there are table, view and index in a database, but I don't have the DDL for these DB object, what tool can I use to generate DDL from that database, thx for your help

  2. #2
    Join Date
    Sep 2002
    Location
    Germany, near Aachen
    Posts
    120
    pgadmin III will show you the ddl for each object in the database.

    pg_dump --schema_only will generate the ddl for all objects in a database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •