From: | reedstrm(at)wallace(dot)ece(dot)rice(dot)edu (Ross J(dot) Reedstrom) |
---|---|
To: | mapaquin(at)cca(dot)qc(dot)ca (Marc Andre Paquin) |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] create table bug: the "no" string can't be a column |
Date: | 1999-06-02 23:53:58 |
Message-ID: | m10pKpa-000LICC@wallace.ece.rice.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Marc -
Try this out:
test=> create table test (no char(8), city int4, region int4);
ERROR: parser: parse error at or near "no"
test=> create table test ("no" char(8), city int4, region int4);
CREATE
test=> \d test
Table = test
+----------------------------------+----------------------------------+-------+
| Field | Type | Length|
+----------------------------------+----------------------------------+-------+
| no | char() | 8 |
| city | int4 | 4 |
| region | int4 | 4 |
+----------------------------------+----------------------------------+-------+
test=> select version();
version
-------------------------------------------------------------
PostgreSQL 6.4.2 on i686-pc-linux-gnu, compiled by gcc 2.7.2.
(1 row)
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> 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);
> --
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Bitmead | 1999-06-03 00:38:25 | Re: [GENERAL] powered by postgresql |
Previous Message | Mike Haberman | 1999-06-02 22:27:29 | PL/pgSQL help |