Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id BD1AC4766E7
	for <pgsql-sql@postgresql.org>; Mon, 16 Sep 2002 11:03:59 -0400 (EDT)
Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178])
	by postgresql.org (Postfix) with ESMTP id 0E5C1476A16
	for <pgsql-sql@postgresql.org>; Mon, 16 Sep 2002 11:03:22 -0400 (EDT)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id 57C7AD605; Mon, 16 Sep 2002 08:03:26 -0700 (PDT)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id 4D7AB5C02; Mon, 16 Sep 2002 08:03:26 -0700 (PDT)
Date: Mon, 16 Sep 2002 08:03:26 -0700 (PDT)
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: jaya prakash <prakashrj@hotmail.com>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: does table names have a format and size
In-Reply-To: <ee5d9.0209131504.2d9f837c@posting.google.com>
Message-ID: <20020916080023.X89488-100000@megazone23.bigpanda.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/178
X-Sequence-Number: 9455


On 13 Sep 2002, jaya prakash wrote:

> Hi,
> 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 - isn't a valid unquoted identifier character.
You can either do "IL18R---_PGA_SNPs666" and always quote the name
or don't use - characters.

I think only letters _ and numbers can be used unquoted (and numbers
can't start), but I haven't checked.