Re: Data dumps to files - best methods?

Поиск
Список
Период
Сортировка
От Ralf Schuchardt
Тема Re: Data dumps to files - best methods?
Дата
Msg-id 6556F93B-7EF2-4922-B7F2-3D87909D0F53@gmx.de
обсуждение исходный текст
Ответ на Re: Data dumps to files - best methods?  ("Machiel Richards" <machielr@rdc.co.za>)
Список pgsql-general
Дерево обсуждения
Hi,

Am 26.07.2010 um 11:46 schrieb Machiel Richards:

       Is there a method of outputting / dumping the data into .xml format as part of the scripts / crons/ db processes?

It depends on your requirements of the xml file format.
psql can output data in html/xhtml format (--html switch), which might or might not be enough for you.

$ psql --html -c "select * from atable" adb > myfile.xhtml.part

"query_to_xml" generates a proper xml version of the query results.


Ralf

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Ralf Schuchardt
Sent: 23 July 2010 01:37 PM
To: Machiel Richards
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Data dumps to files - best methods?
 
Hi,
 
Am 23.07.2010 um 10:32 schrieb Machiel Richards:


       As I am fairly new to postgresql I am trying to find some more info regarding options to dump specific data to files. 


     However, even though I can get the sql query,etc... how will I use this to dump the data into the relevant files?
 
You can use the "\copy" command in psql to export the result of query into a file. For example:
 
> psql -c "\\copy (select * from atable) to 'myfile.csv' with delimiter as ',' csv header" adb
 
will copy all rows from "atable" in "adb" to "myfile.csv" in csv format.
 
 
Ralf

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

Предыдущее
От: Ivan Voras
Дата:
Сообщение: Re: What to do if space for database decrease and no additional hard drive is possible?
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Re: What to do if space for database decrease and no additional hard drive is possible?