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
Date: Mon, 16 Sep 2002 08:03:26 -0700 (PDT)
Message-ID: <20020916080023.X89488-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <ee5d9.0209131504.2d9f837c@posting.google.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, prakashrj@hotmail.com
Subject: Re: does table names have a format and size
In-Reply-To: <20020916080023.X89488-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox