Обсуждение: create table bug: the "no" string cant be a column

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);
--
Marc André Paquin, adjoint au chef  T. I.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Centre Canadien d'Architecture  |   C C A
http://cca.qc.ca

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~