Re: extract data and store

Поиск
Список
Период
Сортировка
От AarniRuuhimäki / Megative Tmi / KYMI.com
Тема Re: extract data and store
Дата
Msg-id 20020725151617.USXH27340.fep07.tmt.tele.fi@there
обсуждение исходный текст
Ответ на extract data and store  (Jesús López <jesulop1@etb.com.co>)
Список 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 по дате отправления:

Предыдущее
От: AarniRuuhimäki / Megative Tmi / KYMI.com
Дата:
Сообщение: Re: extract data and store
Следующее
От: Jesús López
Дата:
Сообщение: Re: extract data and store