Joshua D. Drake wrote:
roopa perumalraja wrote:
Thanks a lot for your immediate reply. can you please tell me how to use the command pg_dump to backup specific tables. Thanks a lot in advance.
pg_dump --help
Better yet, try this first:
"http://www.catb.org/~esr/faqs/smart-questions.html";
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)
O
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of roopa
> perumalraja
> Sent: Sunday, January 14, 2007 8:39 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Backup the part of postgres database
>
>
ent: Sunday, January 14, 2007 8:39 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Backup the part of postgres database
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.
ECTED] On Behalf Of roopa
perumalraja
Sent: Sunday, January 14, 2007 8:39 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Backup the part of postgres database
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
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 w
