key=value imports

From: Robert Fitzpatrick <robert(at)webtent(dot)org>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: key=value imports
Date: 2011-01-19 22:53:16
Message-ID: 4D376B5C.6000703@webtent.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was wondering if someone could help with my new task of trying to
import from an API into PostgreSQL 9.0. An example query would respond
like this...

transactid=164d8355b0f4fc2eb051344d3b6b0b5f
status=SUCCESS
domaincount=3
domain_0_name=example1.com
domain_0_expiration=2011/06/16
domain_0_status=ok
domain_0_registrarlock=enabled
domain_0_transferauthinfo=stye-4284
domain_1_name=example2.com
domain_1_expiration=2011/02/12
domain_1_status=ok
domain_1_registrarlock=enabled
domain_1_transferauthinfo=plap-4093
domain_2_name=example3.com
domain_2_expiration=2011/02/13
domain_2_status=ok
domain_2_registrarlock=enabled
domain_2_transferauthinfo=etas-1176

Based on the domain name, I want to update the other fields in our
table. I can do split routines in plperl, but after I build an hash, I'm
finding it hard to figure out how to feed that back to my plpgsql
function for updates? Or is there a better way or some contrib that
would help better?

Thanks, Robert
--
Robert <robert(at)webtent(dot)org>
________________________________________________________________________
This e-mail message was delivered to you by a WebTent ESMTP mail gateway
after it has been filtered for spam and viruses, see the headers of this
message for details. http://www.webtent.com/email

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-01-19 22:53:34 Re: How to fire triggers just on "top" level DML
Previous Message Adrian Klaver 2011-01-19 22:48:34 Re: How to fire triggers just on "top" level DML