Skip site navigation (1) Skip section navigation (2)

Re: Why can't I see the definition of my relations

From: Andrew Falanga <af300wsm(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Why can't I see the definition of my relations
Date: 2010-07-13 16:27:55
Message-ID: 5ad15592-adae-4b13-9c74-0f06b34f6100@c10g2000yqi.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-general
On Jul 13, 9:12 am, adrian(dot)kla(dot)(dot)(dot)(at)gmail(dot)com (Adrian Klaver) wrote:
> On Monday 12 July 2010 10:18:07 pm A. Kretschmer wrote:
>
>
>
>
>
> > No, the reason is another:
>
> > test=# create table "Stone"(id serial);
> > NOTICE:  CREATE TABLE will create implicit sequence "Stone_id_seq" for
> > serial column "Stone.id" CREATE TABLE
> > test=*# \d Stone
> > Did not find any relation named "Stone".
> > test=*# \d "Stone"
> >                           Table "public.Stone"
> >  Column |  Type   |                      Modifiers
> > --------+---------+------------------------------------------------------
> >  id     | integer | not null default nextval('"Stone_id_seq"'::regclass)
>
> > You have to use the " if the table-name contains upper-case characters.
>
> > Andreas
>
> Just for completeness, it is the quoted table name that causes the case
> sensitivity. If you do as below than the table name is folded to lower case.
>
> test=> create table Stone(id serial);
> NOTICE:  CREATE TABLE will create implicit sequence "stone_id_seq" for serial
> column "stone.id"
> CREATE TABLE
> test=> \d Stone
>                          Table "public.stone"
>  Column |  Type   |                     Modifiers
> --------+---------+----------------------------------------------------
>  id     | integer | not null default nextval('stone_id_seq'::regclass)
>
> --
> Adrian Klaver
> adrian(dot)kla(dot)(dot)(dot)(at)gmail(dot)com
>
> --
> Sent via pgsql-general mailing list (pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

Thank you both for you help.  I look forward to accessing the table
tonight when I get home.

For my own sake, would there happen to be any documentation on-line
that I could read up on regarding this?  (The PostgreSQL website
perhaps?  Is this discussed in their documentation?)

Thanks,
Andy

In response to

Responses

pgsql-general by date

Next:From: Stefan KaltenbrunnerDate: 2010-07-13 17:10:49
Subject: Re: NASA needs Postgres - Nagios help
Previous:From: Bruce MomjianDate: 2010-07-13 16:21:24
Subject: Re: Testing 9.0beta3 and pg_upgrade

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group