Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 7525D63441B for ; Thu, 11 Mar 2010 12:26:20 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 02484-06 for ; Thu, 11 Mar 2010 16:26:09 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id F2CFF6326CE for ; Thu, 11 Mar 2010 12:26:09 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.3/8.14.3) with ESMTP id o2BGQ95V011782 for ; Thu, 11 Mar 2010 12:26:09 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.3/8.14.3/Submit) id o2BG7ljx005133 for pgsql-sql@postgresql.org; Thu, 11 Mar 2010 12:07:47 -0400 (AST) (envelope-from news) From: dennis X-Newsgroups: pgsql.sql Subject: Re: Help : insert a bytea data into new table Date: Fri, 12 Mar 2010 00:07:44 +0800 Organization: Hub.Org Networking Services Lines: 21 Message-ID: References: <20100309034626.GA12083@osiris.mauzo.dyndns.org> <20100309111410.GA15752@osiris.mauzo.dyndns.org> <20100310152510.GA37991@osiris.mauzo.dyndns.org> <20100311114648.GA50794@osiris.mauzo.dyndns.org> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.8) Gecko/20100205 SeaMonkey/2.0.3 In-Reply-To: <20100311114648.GA50794@osiris.mauzo.dyndns.org> To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201003/88 X-Sequence-Number: 33795 Postgres : 8.1.4 Dennis Ben Morrow wrote: > Quoth dennis: >> Dear Ben >> >> thanks for you anwser. >> I try to add function quote_literal on my sql statement . >> >> but it raise other error message (quote_literal not support bytea format): >> function quote_literal(bytea) does not exist > > Which Postgres version are you using? > > Ben > >