Try and remember to CC: the list - there are plenty of other people who
can help too.
chandresh rana wrote:
Hi Richard,
Let me explain you exactly what am trying to achieve.
Am trying to export the database of the sever(ver 7.4) to my local
server(ver 8.2).The problem in exporting ,is that certain tables are of very
huge size which will be take weeks to complete if they are included.So need
to eliminate those tables.
OK. How big are we talking about? What is the size:
1. Of the large table(s)?
2. Of the database as a whole?
After having exporting/importing of the schema and the included tables,now
need to get certain/limited set of record/rows from excluded tables to get
the database start locally.
I would copy the rows I want to a new table (still in the 7.4 database)
and then dump that.
You can have pg_dump dump individual tables (use pg_dump from 8.2, it's
smarter) and then either:
1. rename the table in the dumped file
2. rename it after importing
--
Richard Huxton
Archonet Ltd
