X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CD899528BD for ; Mon, 27 Jun 2005 06:33:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61373-04 for ; Mon, 27 Jun 2005 09:33:55 +0000 (GMT) Received: from WM12.inbox.com (wm12.inbox.com [208.50.6.12]) by svr1.postgresql.org (Postfix) with SMTP id E713752813 for ; Mon, 27 Jun 2005 06:33:52 -0300 (ADT) Received: from inbox.com (127.0.0.1:25) by inbox.com with [InBox.Com ESMTP Server] id <506270002625.WM12> for from ; Mon, 27 Jun 2005 1:33:51 AM -0800 Mime-Version: 1.0 Date: Mon, 27 Jun 2005 01:33:50 -0800 Message-ID: <8CF67941192.0000006As.gnanavel@inbox.com> From: Gnanavel Shanmugam Subject: Re: nemeric table names To: sanskar soni , pgsql-admin@postgresql.org In-Reply-To: X-Mailer: IBISIT WebMail Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.107 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/227 X-Sequence-Number: 17982 double quote the table name as create table =22123=22 ( =2E.. ) The table can be accessed only with double quotes. with regards, S.Gnanavel > -----Original Message----- > From: sanskar.sony=40gmail.com > Sent: Mon, 27 Jun 2005 13:36:46 +0530 > To: pgsql-admin=40postgresql.org > Subject: =5BADMIN=5D 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=