Postgres Pro
Downloads
Home   >   mailing lists

Re: pgadmin III query - Mailing list pgsql-general

From Peter Kroon
Subject Re: pgadmin III query
Date
Msg-id CAOh+DOmzY=oUtqAdsf1vSnhSgTN5pw8tY3NQLdDSRt5BZSgmSg@mail.gmail.com
Whole thread Raw
In response to Re: pgadmin III query  (Ian Lawrence Barwick <barwick@gmail.com>)
Responses Re: pgadmin III query  (Dinesh Kumar <dinesh.kumar@enterprisedb.com>)
List pgsql-general
Tree view
Thanks, but i need a non command line option.


2013/12/6 Ian Lawrence Barwick <barwick@gmail.com>
2013/12/6 Peter Kroon <plakroon@gmail.com>:
> When you click on a table in the "Object browser" you'll see in the "SQL
> pane" the sql that is needed to create that table.
>
> Which function can I call to get that SQL?

You can use the pg_dump command line function for this:

  pg_dump -s -t name_of_table name_of_database

Regards

Ian Barwick

pgsql-general by date:

Previous
From: Ian Lawrence Barwick
Date:
Subject: Re: pgadmin III query
Next
From: vincent elschot
Date:
Subject: Re: postgresql or xquery?