Search Postgresql Archives

Re: pgadmin III query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks, but i need a non command line option.


2013/12/6 Ian Lawrence Barwick <barwick@xxxxxxxxx>
2013/12/6 Peter Kroon <plakroon@xxxxxxxxx>:
> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux