From: | Aarni Ruuhimäki / Megative Tmi / KYMI(dot)com <aarni(dot)ruuhimaki(at)kymi(dot)com> |
---|---|
To: | Jesús López <jesulop1(at)etb(dot)com(dot)co> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: extract data and store |
Date: | 2002-07-25 16:37:02 |
Message-ID: | 20020725163913.BEDO3204.fep06.tmt.tele.fi@there |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi !
How about COPY mytable FROM '/tmp/plain.txt' USING DELIMITERS ',';
Taken that your file is in rows, one row for one record, no need for parsing
or linefeeds / linebreaks:
Like
253,0,2000-02-24,053638447fffffffffffffff,.......................
254,0,2000-02-25,053638448fffffffffffffff,.......................
Of course you will have to first create the table according to your data:
int, boolean?, date, varchar, ...............
BR,
aarni
On Thursday 25 July 2002 07:16 pm, you wrote:
> Hi:
>
> Thanks for your answer. My question is the following:
>
> I have a large plain text external file with registers separated by commas
> like this:
>
> 253,0,2000-02-24,053638447fffffffffffffff,.......................
>
> I need to parse this and put in postgres. What is the best form of parsing
> and how can I do for put this information in database.
>
> Thanks again for your help.
>
> Jlopez.
>
> Aarni Ruuhimäki / Megative Tmi / KYMI.com wrote:
> > 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jesús López | 2002-07-25 16:56:15 | Re: extract data and store |
Previous Message | Jesús López | 2002-07-25 16:16:50 | Re: extract data and store |