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
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 |