> 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