create table bug: the "no" string can't be a column
От | mapaquin@cca.qc.ca (Marc Andre Paquin) |
---|---|
Тема | create table bug: the "no" string can't be a column |
Дата | |
Msg-id | 375573C6.BA879778@cca.qc.ca обсуждение исходный текст |
Ответы |
Re: [GENERAL] create table bug: the "no" string can't be a column
Re: [GENERAL] create table bug: the "no" string can't be a column |
Список | pgsql-general |
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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
В списке pgsql-general по дате отправления: