Re: does table names have a format and size

Поиск
Список
Период
Сортировка
От Michael Paesold
Тема Re: does table names have a format and size
Дата
Msg-id 011c01c25d87$819cf2f0$4201a8c0@beeblebrox
обсуждение исходный текст
Ответ на does table names have a format and size  (prakashrj@hotmail.com (jaya prakash))
Ответы Re: does table names have a format and size
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How can unique columns being case-insensitive be accomplished?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Table alias in DELETE statements