double quote the table name as create table "123" ( ... ) The table can be accessed only with double quotes. with regards, S.Gnanavel > -----Original Message----- > From: sanskar.sony@xxxxxxxxx > Sent: Mon, 27 Jun 2005 13:36:46 +0530 > To: pgsql-admin@xxxxxxxxxxxxxx > Subject: [ADMIN] nemeric table names > > Hi all I want to create table in my database, But the table name must > begin from numric value. > Such As: > CREATE TABLE 123 ( > name VARCHAR(20), > phone CHAR(20) > ); > > When i do this i got error message. Bottomline is that i want table > name starting with numeric value. Can anyone let me know how to do > this in postgresql? > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings
