Re: extract data and store - Mailing list pgsql-novice

From AarniRuuhimäki / Megative Tmi / KYMI.com
Subject Re: extract data and store
Date
Msg-id 20020725151617.USXH27340.fep07.tmt.tele.fi@there
Whole thread Raw
In response to extract data and store  (Jesús López <jesulop1@etb.com.co>)
List pgsql-novice
Hi Jesus !

You can use COPY command in psql to import txt and csv files.

If you want just parts from your text you will have to search / parse the
file first.

For the parsing, I am afraid, you will have to write a bit of code in your
preferred language. If you are using some common tools / APIs like php or
cfml, there are plenty of custom functions and little scriplets readily
available.

Could you be a little more specific on 'some information' and 'external text
file' please ?

BR,

aarni



On Thursday 25 July 2002 02:29 am, you wrote:
> Hi:
>
> I´m novice in postgress and i need to take some information from a
> external plain text file and store in postgress.
>
> There are any aplication to do that ? what is the best form to do it?
>
> Thanks.
>
> Jlopez.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html


pgsql-novice by date:

Previous
From: AarniRuuhimäki / Megative Tmi / KYMI.com
Date:
Subject: Re: extract data and store
Next
From: Jesús López
Date:
Subject: Re: extract data and store