Thread: importing limited set of rows/tuples

Hi All,

I have eliminated certain tables while exporting as the size of the data in
the tables are huge.Though am having the schema which contains all the
tables.

Now I want to import limited set of records/rows ( 1000 tuples ) from the
eliminated tables.

Is this possible? If yes, please tell me how to accomplish this?

Secondly, like to know how postgresql take care of all the
constraints/referential integrity while importing the records from the
different tables?

Cheers,
Cha
--
View this message in context: http://www.nabble.com/importing-limited-set-of-rows-tuples-tf4011639.html#a11392319
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Hi,

Le lundi 02 juillet 2007, cha a écrit :
> Now I want to import limited set of records/rows ( 1000 tuples ) from the
> eliminated tables.
>
> Is this possible? If yes, please tell me how to accomplish this?

If you have CSV or CSV-like data file format, you can use pgloader with the -C
option, you can even load from any line in the file (given by number or data
id, multi-column keys supported) :
  http://pgfoundry.org/projects/pgloader

Regards,
--
dim