pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: prakashrj@hotmail.com
To: pgsql-sql@postgresql.org
Subject: does table names have a format and size
Date: 13 Sep 2002 16:04:42 -0700
Message-ID: <ee5d9.0209131504.2d9f837c@posting.google.com> (raw)

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



view thread (4+ messages)  latest in thread

Message-ID: <ee5d9.0209131504.2d9f837c@posting.google.com>
Permalink:  ../ee5d9.0209131504.2d9f837c@posting.google.com/
Also on:    postgresql.org/message-id/ee5d9.0209131504.2d9f837c@posting.google.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: prakashrj@hotmail.com
  Subject: Re: does table names have a format and size
  In-Reply-To: <ee5d9.0209131504.2d9f837c@posting.google.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox