Re: [GENERAL] create table bug: the "no" string can't be a column

On Wed, 2 Jun 1999, Marc Andre Paquin wrote:

> Hello,
>
> I am transfering data from a database Postgres 6.0 to a 6.4 version.
>
> The pg_dump wont do the trick...
>
> I had to create the database manually on 6.4. So I must replacate the exact
> structure of the old  database. But I can't! One of my column name is "no" for
> number in french... It seems that I get an error message with a create table
> statment. I have tried to trick it: I named the column "no" to "noo" and tried to
> alter table to change the name afterwards... no luck. But the "noo" is working fine!
> Changing the "no" column is not an option... many programs depends on it!!!
>
> What can I do? What would be the right syntax?
>
> create table test (no char(8), city int4, region int4);

Try it as:

create table test ("no" char(8), city int4, region int4);

scrappy=> insert into test (no,city,region) values ('1',2,3);
ERROR:  parser: parse error at or near "no"
scrappy=> insert into test ("no",city,region) values ('1',2,3);
INSERT 4293227 1

You always have to use the "'s around no though...

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org