From: Michael Paesold <mpaesold@gmx.at>
To: pgsql-sql@postgresql.org
Subject: Re: does table names have a format and size
Date: Mon, 16 Sep 2002 15:46:48 +0200
Message-ID: <011c01c25d87$819cf2f0$4201a8c0@beeblebrox> (raw)
References: <ee5d9.0209131504.2d9f837c@posting.google.com>
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
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: mpaesold@gmx.at
Subject: Re: does table names have a format and size
In-Reply-To: <011c01c25d87$819cf2f0$4201a8c0@beeblebrox>
* 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