Re: [GENERAL] 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@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@iol.ie