Re: extract data and store

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