Re: problem importing data with psql

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