Re: Not existing relations ...

From: Antonio Fiol Bonnín <fiol(at)w3ping(dot)com>
To: linux <rysiekll(at)vicom(dot)ig(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Not existing relations ...
Date: 2001-11-28 13:40:12
Message-ID: 3C04E93C.42D660B7@w3ping.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> DataBase=# \dt
> List of relations
> Name | Type | Owner
> -------------------+-------+----------
> FirstTable | table | postgres
> SecondTable | table | postgres
> ThirdTable | table | postgres
> (3 rows)
>
> DataBase=# select * from FirstTable;
> ERROR: Relation 'firsttable' does not exist

select * from "FirstTable";

will probably work.

You may also (if you do not need to access them from MSAccess any more)

ALTER TABLE "FirstTable" RENAME TO firsttable;

If you do not enclose the table names in double quotes ("), they are
converted to lower case, AFAIK.

Good luck!

Antonio

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albert Bartoszko 2001-11-28 14:07:51 Rules
Previous Message Ben-Nes Michael 2001-11-28 13:38:03 ver 7.2