Re: does table names have a format and size - Mailing list pgsql-sql

From Michael Paesold
Subject Re: does table names have a format and size
Date
Msg-id 011c01c25d87$819cf2f0$4201a8c0@beeblebrox
Whole thread Raw
In response to does table names have a format and size  (prakashrj@hotmail.com (jaya prakash))
Responses Re: does table names have a format and size
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: How can unique columns being case-insensitive be accomplished?
Next
From: Bruce Momjian
Date:
Subject: Re: Table alias in DELETE statements