Re: importing limited set of rows/tuples - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: importing limited set of rows/tuples
Date
Msg-id 200707021441.59885.dfontaine@hi-media.com
Whole thread Raw
In response to importing limited set of rows/tuples  (cha <chandresh.rana@metrixline.com>)
List pgsql-general
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

Attachment

pgsql-general by date:

Previous
From: "Ashish Karalkar"
Date:
Subject: Re: Tables not created in proper schema
Next
From: "Jason L. Buberel"
Date:
Subject: Re: recovery_target_time ignored or recovery alwaysrecovers to end of WAL