From: Ben Morrow <ben@morrow.me.uk>
To: dennis@teltel.com
To: pgsql-sql@postgresql.org
Subject: Re: Help : insert a bytea data into new table
Date: Tue, 9 Mar 2010 11:14:10 +0000
Message-ID: <20100309111410.GA15752@osiris.mauzo.dyndns.org> (raw)
In-Reply-To: <hn4ub5$n7f$1@news.hub.org>
References: <hn49e1$2eob$1@news.hub.org>
<20100309034626.GA12083@osiris.mauzo.dyndns.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ben@morrow.me.uk, dennis@teltel.com
Subject: Re: Help : insert a bytea data into new table
In-Reply-To: <20100309111410.GA15752@osiris.mauzo.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox