Export SELECT statement as SQL queries in file

Поиск
Список
Период
Сортировка
От Mario Peshev
Тема Export SELECT statement as SQL queries in file
Дата
Msg-id cd539d7e0705040645h7b532933gd8a6f58ec9d10c6e@mail.gmail.com
обсуждение исходный текст
Ответы Re: Export SELECT statement as SQL queries in file  (Sean Davis <sdavis2@mail.nih.gov>)
Список pgsql-novice
Hey there,

I'm interested in getting the content of a SQL query into a file (possibly as an INSERT clause). Is it possible to be done with an SQL statement? Now I think it could be realised as [\copy (statement) to 'file'] construction, but it's psql command. Is there another way?

Thanks in advance,
Mario

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

Предыдущее
От: Phillip Smith
Дата:
Сообщение: Re: Importing a CSV file to a table on Postgres
Следующее
От: Sean Davis
Дата:
Сообщение: Re: Export SELECT statement as SQL queries in file