Re: Backup the part of postgres database

Поиск
Список
Период
Сортировка
От Shoaib Mir
Тема Re: Backup the part of postgres database
Дата
Msg-id bf54be870701150140p32940b76y241078a9c4aba749@mail.gmail.com
обсуждение исходный текст
Ответ на Backup the part of postgres database  (roopa perumalraja <roopabenzer@yahoo.com>)
Список pgsql-general
COPY command might also help....

COPY (SELECT * FROM country WHERE country_name LIKE 'A%') TO '/usr1/proj/bray/sql/a_list_countries.copy';

Details can be found at --> http://www.postgresql.org/docs/current/static/sql-copy.html

------------------
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)

On 1/15/07, roopa perumalraja <roopabenzer@yahoo.com> wrote:
Hi all,
 
Is it possible to back up only part of my database for example from tables which have data from April to July 2006, if so what will be the command for that.
 
Thanks a lot in advance
Roopa


It's here! Your new message!
Get new email alerts with the free Yahoo! Toolbar.


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

Предыдущее
От: "Philippe Lang"
Дата:
Сообщение: Re: XEON familiy 5000, 5100 or 5300?
Следующее
От: "Jan van der Weijde"
Дата:
Сообщение: Performance with very large tables