From: | Alban Hertroys <haramrae(at)gmail(dot)com> |
---|---|
To: | Egon Frerich <egon(at)frerich(dot)eu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Why is table not found? |
Date: | 2017-01-31 14:00:43 |
Message-ID: | 48F2DECC-86EF-48C4-BD59-FBD390F5B472@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> On 31 Jan 2017, at 14:45, Egon Frerich <egon(at)frerich(dot)eu> wrote:
>>
>> CREATE TABLE "Raum"
>> (
>> "RaumID" serial NOT NULL, -- Automatisch vergebenes
> But psql tells me "Raum" is not existent:
>
>> egon(at)xfEinzel ~ $ psql Hausrat
>> psql (9.3.15)
>> Type "help" for help.
>>
>> Hausrat=# SELECT * FROM Raum;
>> ERROR: relation "raum" does not exist
>> LINE 1: SELECT * FROM Raum;
Instead of adding quotes to your select statement (as others suggested), IMHO the better thing to do is to remove them from your create statements. Most of the time there is no benefit creating case-sensitive identifiers in a database.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.
From | Date | Subject | |
---|---|---|---|
Next Message | Egon Frerich | 2017-01-31 14:17:52 | Re: Why is table not found? |
Previous Message | John McKown | 2017-01-31 13:53:09 | Re: Why is table not found? |