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
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?? |