Hi Dinesh, SELECT pg_reload_conf(); Did not do the job, I had to restart the server. I managed to collect the queries and there are a lot of them to show the SQL that is needed to create the given table. Does postrgesql have any plan on making their own function for this?
Best, Peter 2013/12/9 Dinesh Kumar <dinesh.ku...@enterprisedb.com> > Hi Peter, > > On Mon, Dec 9, 2013 at 7:03 PM, Peter Kroon <plakr...@gmail.com> wrote: > >> Hi Dinesh, >> >> >> >Get all the queries what it has performed. >> >> How and where? >> When I run "select * from pg_stat_activity" I get the same result with >> and without "log_minduration_statement=0" >> >> > By setting this parameter log_min_duration_statement to 0, postgres will > log all the queries, in the pg_log file. > > Hope the following steps helps you on this, and make sure you have enabled > the logging_collector. > > 1. Modify the above parameter on the required postgres cluster. > > 2. Do SELECT pg_reload_conf(); on the same machine. > > 3. And go to pg_log file location, and do tail -f current pg_log file. > > 4. Go to pgadmin, and refresh on any table. > > 5. Check the tail -f <pg_log>file output. There you will find all the sql > queries, which have been executed from pgAdmin. > > 6. Collect those queries, and make your own custom function with pl/pgsql > language. > > Regards, > Dinesh > > >> Could you provide a more detailed step by step guide? >> >> Best, >> Peter >> >> >> >> 2013/12/9 Dinesh Kumar <dinesh.ku...@enterprisedb.com> >> >>> 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 >>>>> >>>> >>>> >>> >> >
