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"
Could you provide a more detailed step by step guide?Best,Peter2013/12/9 Dinesh Kumar <dinesh.kumar@enterprisedb.com>Hi,On Fri, Dec 6, 2013 at 4:34 PM, Peter Kroon <plakroon@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 <barwick@gmail.com>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
Hi,On Fri, Dec 6, 2013 at 4:34 PM, Peter Kroon <plakroon@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 <barwick@gmail.com>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
Thanks, but i need a non command line option.
2013/12/6 Ian Lawrence Barwick <barwick@gmail.com>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
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
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных