oh, silly me.
I was making a dump of a PostgreSQL 8.4.17 backend with pg_dump
(PostgreSQL) 9.1.9
On Mon, May 13, 2013 at 4:24 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> willybas(at)gmail(dot)com writes:
> > pg_dump (PostgreSQL) 9.1.9 ends in an error when backing up my db, which
> > contains a field called "new".
>
> Works for me:
>
> regression=# create table new (f1 text, new text);
> CREATE TABLE
> regression=# insert into new (f1, new) values ('1','2');
> INSERT 0 1
> regression=# copy new(f1,new) to stdout;
> 1 2
>
> You sure the server is 9.1?
>
> regards, tom lane
>
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth