Re: pgadmin III query - Mailing list pgsql-general

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