nemeric table names
nemeric table names
От:
sanskar soni <sanskar.sony@gmail.com>
Дата:
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?
Re: nemeric table names
От:
Gnanavel Shanmugam <s.gnanavel@inbox.com>
Дата:
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@gmail.com > Sent: Mon, 27 Jun 2005 13:36:46 +0530 > To: pgsql-admin@postgresql.org > 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