Re: pgadmin III query

Поиск
Список
Период
Сортировка
От Dinesh Kumar
Тема Re: pgadmin III query
Дата
Msg-id CAKWsr7hRRc4Kb8YE_O6Y37fpG7OXsUSPXKAFO6JJjeW9UVfoqw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgadmin III query  (Peter Kroon <plakroon@gmail.com>)
Список pgsql-general
Дерево обсуждения
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Set returning aggregate?
Следующее
От: Joek Hondius
Дата:
Сообщение: network protocol and compatibility question