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 >>>> >>> >>> >> >