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
roopa perumalraja wrote:
> Hi Adam,
>
> 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
>
> Regards
> Roopa
>
> Adam Rich <[EMAIL PROTECTED]> wrote:
> Roopa,
>
Hi Adam,
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.
Regards
Roopa
Adam Rich <[EMAIL PROTECTED]> wrote:
Roopa,
You can use the command pg_dump to backup specific tables.
Roopa,
You can use the command pg_dump to backup specific tables. But you
won't be able to
restrict the backup to specific rows. (You can always create a separate
table just for backups,
and dump just that table).
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
