Re: Postgresql string parsing - Mailing list pgsql-general

From Tony Caduto
Subject Re: Postgresql string parsing
Date
Msg-id 442AC1A6.7080407@amsoftwaredesign.com
Whole thread Raw
In response to Postgresql string parsing  (ycrux@club-internet.fr)
Responses Re: Postgresql string parsing  (Jim Nasby <jnasby@pervasive.com>)
List pgsql-general
ycrux@club-internet.fr wrote:
> Hi Folks,
> I'm looking for the fatest way to parse string in a postgresql function and insert each parsed chunk in a table.
Somethinglike that: 
>
>
You might be able to use the |string_to_array function which |splits a
string into array elements using the provided delimiter which could be a
EOL marker.
Then use a loop to iterate through the  array  and  insert  into  your
table.

Just a quick idea :-)
||

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration


pgsql-general by date:

Previous
From: Bob Pawley
Date:
Subject: Re: Connecting
Next
From: Steve Atkins
Date:
Subject: Re: PostgreSQL's XML support comparison against other RDBMSes