Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 621CA9FBFC3 for ; Fri, 13 Jul 2007 04:34:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 48775-08 for ; Fri, 13 Jul 2007 04:34:05 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.238]) by postgresql.org (Postfix) with ESMTP id 32DCE9FBBA6 for ; Fri, 13 Jul 2007 04:34:13 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id l8so336298nzf for ; Fri, 13 Jul 2007 00:34:07 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:from:to:cc:references:in-reply-to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:content-language; b=eN1hbvAG12dWPyfx3m12qo+BqfOtMdo6N6NkdhDBymVN6lH3WJ2uwcjUJrZcrN6Z0iRwjAPpJ/OGEuLTXVs9PgCxfQPQ8clZreIAfePhwCrsVF6dLc5EaP5Bypoh7XDozLHOv8HWrh6y6EZ3Fu+bI6sxVXwMoHsvruVrxC6vbBg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:from:to:cc:references:in-reply-to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:content-language; b=XC8L+PLUSx7OpB1XMxGoOC5WIJUDFRlZBN0N7LjfulQ3Hdhw5tShRpajQQUX0p59OBZuP49qqPolNn1OUeOOyf1xnZrk/O4oAktUIg4Hwfq0lZNCmek2BGmKcjrvGDQKvZ8gh12+ygDACRqISOQHP6imM2sIcps35cK9P/UQhhk= Received: by 10.141.68.10 with SMTP id v10mr396895rvk.1184312047306; Fri, 13 Jul 2007 00:34:07 -0700 (PDT) Received: from bitdldt04 ( [122.162.171.165]) by mx.google.com with ESMTP id c3sm12607926rvf.2007.07.13.00.34.04 (version=SSLv3 cipher=RC4-MD5); Fri, 13 Jul 2007 00:34:06 -0700 (PDT) From: "Jyoti Seth" To: "'Richard Huxton'" Cc: References: <00b101c7c51d$7754fb50$65fef1f0$@com> <46972930.30301@archonet.com> In-Reply-To: <46972930.30301@archonet.com> Subject: Re: calling webservice through postgresql function Date: Fri, 13 Jul 2007 13:01:30 +0530 Message-ID: <00b601c7c51f$d775d430$86617c90$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcfFH25jPwm+T7DoQdezBVch7YzUvQAAC3PQ Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/80 X-Sequence-Number: 28815 Thanks a lot for ur quick response. I have searched a lot on net for code to call a webservice through tcl/tk or any other scripting lang that is supported by postgresql, but couldn't find one. If u can provide me some code to call a web service through postgresql it would be a great help. Thanks, Jyoti Setj -----Original Message----- From: Richard Huxton [mailto:dev@archonet.com] Sent: Friday, July 13, 2007 12:57 PM To: Jyoti Seth Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] calling webservice through postgresql function Jyoti Seth wrote: > Hi all, > > I want to call webservice from my postgresql database. Please let me know if > anyone has idea. You can use any of the "untrusted" procedural languages to access resources outside the database (e.g. pl/perlu), or of course C. -- Richard Huxton Archonet Ltd