From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | Marc Andre Paquin <mapaquin(at)cca(dot)qc(dot)ca> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] create table bug: the "no" string can't be a column |
Date: | 1999-06-03 04:21:12 |
Message-ID: | Pine.BSF.4.05.9906030118440.413-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Bitmead | 1999-06-03 05:56:34 | Re: [GENERAL] Implementing hierarchy |
Previous Message | Kevin Heflin | 1999-06-03 04:17:31 | Error when creating tables |