Hi, On Fri, Dec 6, 2013 at 4:34 PM, Peter Kroon <plakr...@gmail.com> wrote:
> Thanks, but i need a non command line option. > > We can do this with a function which is having the sql queries of pgAdmin raised against the database. => Log all the queries by enabling "log_minduration_statement=0". => Do SELECT pg_reload_conf(); => Do a refresh on a table of pgAdmin's browser. => Get all the queries what it has performed. => Create a custom function with those queries. Regards, Dinesh > > 2013/12/6 Ian Lawrence Barwick <barw...@gmail.com> > >> 2013/12/6 Peter Kroon <plakr...@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 >> > >
