On Tue, Jan 31, 2017 at 7:45 AM, Egon Frerich <egon@frerich.eu> 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; > ^ > Hausrat=#
Why?
Because, "Raum" is not equal to Raum. This is because, when a name is not enclosed in " marks, PostgreSQL will force it to be lower case. So "Raum" is mixed cased, as you would expect. But Raum is basically converted to "raum".