Re: Why is table not found?

On 31/01/17 13:45, Egon Frerich wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I created a db 'Hausrat' with a table "Raum". If I look in pgadmin I
> find the the table. In sql field is shown:
>
>> -- Table: "Raum"
>>
>> -- DROP TABLE "Raum";
>>
>> CREATE TABLE "Raum"
>> (
>> "RaumID" serial NOT NULL, -- Automatisch vergebenes
> Identifizierungsmerkmal für den Raum
>> "Raum" character varying(15), -- Bezeichnung des Raums
>> CONSTRAINT "Raum_pkey" PRIMARY KEY ("RaumID")
>> )
>> WITH (
>> OIDS=FALSE
>> );
>> ALTER TABLE "Raum"
>> OWNER TO egon;
>> COMMENT ON COLUMN "Raum"."RaumID" IS 'Automatisch vergebenes
> Identifizierungsmerkmal für den Raum';
>> COMMENT ON COLUMN "Raum"."Raum" IS 'Bezeichnung des Raums';
>>
>>
>> -- Index: "Raum_RaumID_idx"
>>
>> -- DROP INDEX "Raum_RaumID_idx";
>>
>> CREATE INDEX "Raum_RaumID_idx"
>> ON "Raum"
>> USING btree
>> ("RaumID");
>>
> 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;

Object names are folded to lower-case automatically, unless you enclose
them in double-quotes:

select * from "Raum";

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie