Re: [PORTS] Port Bug Report: Can not create table with a number as first character - Mailing list pgsql-ports

> Summary: Can not create table with a number as first character
>   PostgreSQL version : 6.4.2
> create table 622 (etc char(25));
> create table v-22 (etc char(10));

You must use the SQL92 conventions to accomplish this:

postgres=> create table "622" (etc char(25));
CREATE
postgres=> insert into "622" values ('hi there');
INSERT 144982 1
postgres=> select * from "622";
etc
-------------------------
hi there
(1 row)

Same with your hyphen example. Good luck.

                   - Tom