Re: [ADMIN] pg_dump: Exclude multiple tables in version 7.4

2007-06-21 Thread cha
Hi, Am able to figure out the solution for the issue. I accomplish the task by writing the ant script and batch file. In the batch file am passing the table name as arguments. Only thing I had to do manually is to list out the name of the tables in batch file. Cheers, Cha cha wrote: > > Hi A

Re: [ADMIN] pg_dump: Exclude multiple tables in version 7.4

2007-06-19 Thread Tom Lane
cha <[EMAIL PROTECTED]> writes: > I want to dump the database by using pg_dump command but the problem is the > version at the server is 7.4 which doesn't support the provision for > excluding tables as in version 8.2. If you're dumping with the intent to update to 8.2, you could use 8.2's pg_dum

[ADMIN] pg_dump: Exclude multiple tables in version 7.4

2007-06-19 Thread cha
Hi All, I want to dump the database by using pg_dump command but the problem is the version at the server is 7.4 which doesn't support the provision for excluding tables as in version 8.2. There are 500+ tables in the database,from which 15-20 are of huge sizes.I want to exclude them.Is there a