Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D7E6C9FBB2C for ; Fri, 13 Jul 2007 04:37:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 79395-04 for ; Fri, 13 Jul 2007 04:37:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id 240889FB955 for ; Fri, 13 Jul 2007 04:37:52 -0300 (ADT) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id C8DFE14CE46; Fri, 13 Jul 2007 08:37:46 +0100 (BST) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id AAEDE27411A; Fri, 13 Jul 2007 08:37:46 +0100 (BST) Message-ID: <46972BCA.5050605@archonet.com> Date: Fri, 13 Jul 2007 08:37:46 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.0 (X11/20070326) MIME-Version: 1.0 To: Jyoti Seth Cc: pgsql-sql@postgresql.org Subject: Re: calling webservice through postgresql function References: <00b101c7c51d$7754fb50$65fef1f0$@com> <46972930.30301@archonet.com> <00b601c7c51f$d775d430$86617c90$@com> In-Reply-To: <00b601c7c51f$d775d430$86617c90$@com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/81 X-Sequence-Number: 28816 Jyoti Seth wrote: > 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. Just use pl/perlu (or pythonu or tclu) in whatever way you would normally "call a webservice". That side of things has nothing to do with PG (other than the fact that it will hold up your query). If you don't know how to "call a webservice" then you'll need to check with one of the developer forums for your language of choice I'm afraid. -- Richard Huxton Archonet Ltd