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
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
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
Hi Peter,
On Mon, Dec 9, 2013 at 7:52 PM, Peter Kroon plakr...@gmail.com wrote:
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
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?
Best,
Peter
There is no ready available function to generate the reverse engineered
query.
pgAdmin III generates it from the metadata (table information) available.
On Fri, Dec 6, 2013 at 4:17 PM, Peter Kroon plakr...@gmail.com wrote:
When you click on a table in the Object browser you'll see in the SQL
use pg_dump -s can get the DDL SQL.
jov
在 2013-12-6 下午6:50,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?
Best,
Peter
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
Thanks, but i need a non command line option.
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