does table names have a format and size

From: prakashrj(at)hotmail(dot)com (jaya prakash)
To: pgsql-sql(at)postgresql(dot)org
Subject: does table names have a format and size
Date: 2002-09-13 23:04:42
Message-ID: ee5d9.0209131504.2d9f837c@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

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));

following command works well...

create table MD1_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));

thanks
Prakash

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message pacquet 2002-09-13 23:18:54 "Inverting" a table, OLAP-style
Previous Message Yudie 2002-09-13 19:17:13 How to select and result row number??