Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 5FB7B1337B7E for ; Fri, 22 Oct 2010 08:53:56 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 12732-02 for ; Fri, 22 Oct 2010 11:53:49 +0000 (UTC) Received: from news.hub.org (unknown [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 922A61337B54 for ; Fri, 22 Oct 2010 08:53:48 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.4/8.14.4) with ESMTP id o9MBrmIY024963 for ; Fri, 22 Oct 2010 08:53:48 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.4/8.14.4/Submit) id o9MBfCsN098873 for pgsql-sql@postgresql.org; Fri, 22 Oct 2010 08:41:12 -0300 (ADT) (envelope-from news) From: Maruti Nandan X-Newsgroups: pgsql.sql Subject: insert record in remote database Date: Fri, 22 Oct 2010 04:41:12 -0700 (PDT) Organization: http://groups.google.com Lines: 11 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 X-Complaints-To: groups-abuse@google.com Complaints-To: groups-abuse@google.com Injection-Info: w38g2000pri.googlegroups.com; posting-host=61.16.252.146; posting-account=wbi-ZwoAAABC-v84Kzqb_41QsldrG-JO User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US) AppleWebKit/533.4 (KHTML, like Gecko) Chrome/5.0.375.70 Safari/533.4,gzip(gfe) To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.593 tagged_above=-5 required=5 tests=BAYES_50=0.8, RDNS_NONE=0.793 X-Spam-Level: * X-Archive-Number: 201010/51 X-Sequence-Number: 34702 have any one idea !!! postgres db, to insert record in a table of other database through function!!! u see the dblink , but it just use for select statement i want to when trigger fire i want to insert record in other db --