Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A63C34767A3 for ; Mon, 16 Sep 2002 09:47:42 -0400 (EDT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 006CA476419 for ; Mon, 16 Sep 2002 09:45:05 -0400 (EDT) Received: (qmail 18795 invoked by uid 0); 16 Sep 2002 13:45:08 -0000 Received: from chello062178186201.1.15.tuwien.teleweb.at (HELO beeblebrox) (62.178.186.201) by mail.gmx.net (mp011-rz3) with SMTP; 16 Sep 2002 13:45:08 -0000 Message-ID: <011c01c25d87$819cf2f0$4201a8c0@beeblebrox> From: "Michael Paesold" To: References: Subject: Re: does table names have a format and size Date: Mon, 16 Sep 2002 15:46:48 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/172 X-Sequence-Number: 9449 jaya prakash wrote > Is the name of the table important in psql... because the following > create table command doesn't create any table in the database but the > next sql command with a different table name creates the table. > > Is there any table name convention in postgres. > > create table IL18R---_PGA_SNPs666 (contig char(10),contig_pos > char(10),read_pos char(10),chromat char(30),sample char(30),allele1 > char(20),allele2 char(20),ref_pos char(10),ref_sample char(10),tag > char(100),source char(10)); I believe the hyphen "-" character is not allowed in a table name. Only letters, numbers, underscore "_". Regards, Michael