Hi Peter,
On Mon, Dec 9, 2013 at 7:52 PM, Peter Kroon 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 postrgesql h
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:03 PM, Peter Kroon 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_mi
Hi,
On Fri, Dec 6, 2013 at 4:34 PM, Peter Kroon 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_rel
Thanks, but i need a non command line option.
2013/12/6 Ian Lawrence Barwick
> 2013/12/6 Peter Kroon :
> > 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 c
2013/12/6 Peter Kroon :
> 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_data
use pg_dump -s can get the DDL SQL.
jov
在 2013-12-6 下午6:50，"Peter Kroon" 写道：
> 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 wrote:
> When you click on a table in the "Object browser" you'll see in the "SQL
> pane" the sql
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
