Re: importing limited set of rows/tuples

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: importing limited set of rows/tuples
Date: 2007-07-02 12:41:56
Message-ID: 200707021441.59885.dfontaine@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message ujkavlade 2007-07-02 13:06:11 HAVING clause working in postgres 8.0, but not in 8.2
Previous Message Ashish Karalkar 2007-07-02 11:52:16 Re: Tables not created in proper schema