Thread: pg_dump: Exclude multiple tables in version 7.4
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 any way to do it? I knw that I have to use include instead of excluding the tables.Do I have to include each and every tables manually or is there way to do that? Do i have to write the script for this? if yes, how should I proceed? Please help me out with this issue. Thanks in Advance. Cheers, Cha -- View this message in context: http://www.nabble.com/pg_dump%3A-Exclude-multiple-tables-in-version-7.4-tf3944402.html#a11188794 Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
cha <chandresh.rana@metrixline.com> 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_dump.
regards, tom lane
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 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 any way to do it? > > I knw that I have to use include instead of excluding the tables.Do I have > to include each and every tables manually or is there way to do that? > > Do i have to write the script for this? if yes, how should I proceed? > > Please help me out with this issue. > > Thanks in Advance. > > > Cheers, > Cha > -- View this message in context: http://www.nabble.com/pg_dump%3A-Exclude-multiple-tables-in-version-7.4-tf3944402.html#a11235484 Sent from the PostgreSQL - admin mailing list archive at Nabble.com.