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

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)klaver(at)gmail(dot)com