Re: does table names have a format and size

From: "Michael Paesold" <mpaesold(at)gmx(dot)at>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: does table names have a format and size
Date: 2002-09-16 13:46:48
Message-ID: 011c01c25d87$819cf2f0$4201a8c0@beeblebrox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Paesold 2002-09-16 13:58:23 Re: cross tab (pivtor table) sql
Previous Message Tom Lane 2002-09-16 13:38:46 Re: How can unique columns being case-insensitive be accomplished?