Re: does table names have a format and size

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.