Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 18AA5476DCB for ; Fri, 13 Sep 2002 19:29:21 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id ABE31476DAC for ; Fri, 13 Sep 2002 19:29:20 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id C5C1B3825A3; Fri, 13 Sep 2002 19:29:19 -0400 (EDT) From: prakashrj@hotmail.com (jaya prakash) X-Newsgroups: comp.databases.postgresql.sql Subject: does table names have a format and size Date: 13 Sep 2002 16:04:42 -0700 Organization: http://groups.google.com/ Lines: 22 Message-ID: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/169 X-Sequence-Number: 9446 Hi, 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)); following command works well... create table MD1_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)); thanks Prakash