Re: Postgresql string parsing

From: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql string parsing
Date: 2006-03-29 17:19:34
Message-ID: 442AC1A6.7080407@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

ycrux(at)club-internet(dot)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. Something like 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2006-03-29 17:21:24 Re: PostgreSQL's XML support comparison against other RDBMSes
Previous Message ycrux 2006-03-29 16:51:23 Postgresql string parsing