Date: Tue, 9 Mar 2010 11:14:10 +0000
From: Ben Morrow <ben@morrow.me.uk>
To: dennis@teltel.com, pgsql-sql@postgresql.org
Subject: Re: Help : insert a bytea data into new table
Message-ID: <20100309111410.GA15752@osiris.mauzo.dyndns.org>
References: <hn49e1$2eob$1@news.hub.org>
	<20100309034626.GA12083@osiris.mauzo.dyndns.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <hn4ub5$n7f$1@news.hub.org>
Organization: Who, me?
User-Agent: Mutt/1.5.20 (2009-06-14)

Quoth dennis <dennis@teltel.com>:
> here is example
> 
> table name is "mail":
> column    |   type
> -------------------------
> sender    |char
> subject   |char

I presume you mean 'varchar'?

> content   |bytea
> 
> 
> I want copy some record into new table 'mail_new'.
> 
> sql:
> create table mail_new as select * from mail sender='dennis'

You omitted the WHERE. It's very hard to see what's actually going on
when you keep mis-typing the commands you used.

> result has an error:
> operator does not exist: text || bytea
> 
> 
> But if my sql statement has no column "content"
> the sql works.
> sql:
> create table mail_new as select sender,subject from mail sender='dennis'

No, it still doesn't give that error for me. Show us something you've
*actually* *tried*.

Ben