On Tue, Jan 31, 2017 at 7:45 AM, Egon Frerich <e...@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". ref: https://www.postgresql.org/docs/9.5/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS > > Egon > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v2.0.22 (GNU/Linux) > > iQIbBAEBAgAGBQJYkJTwAAoJECc7nbY+bg5uiRQP9iC4UtbHpPvdvV796fxcMSFp > dncPHzkTKHvcEh3V9t/Xn/BzEHBDAO6RO8jmU18Ja9f/0nOyNXrWxal0OJZXint5 > l3/qRKbekkl7zfogysh4XgZQkpWwsJcYDGoG5tCUQm8TJ3sCk9a9+mbkDhy0Vsev > MPeyYl/fYvlTBkiRmlPZTOX7YjRzeryKXguB3PBke3Vo6SZ1GGGGsFWnMjJ7bc2b > 4cW9hmInmwXZ4EBOfcUW4QnfM0mgHBMGxJwYVQfeC6fQeqT8emh0KQLqozjFe/tk > KNKDU0RebcrBgXP/lIGI34XahZW+WOdLli/t8wBUNiINruY2FlizuH6Uuak3tLjC > cD7vi0SzNK2YFr9Rozw8ow9WVxSfjWBLiOA1GkFdhxKb80NLHthzo8oIVaCqz0bj > 71kA0ewgZ9NMay6ch1VjqSPPFhAZHc1Ho3xIAa0BsZpvEdccDBsL+yk/6DGDYua9 > 5oT1p6CZqfDJqxEIoUiNaJEKm3An5ySN8hHn527/apG9yA9QMh5qJPHA0wRqtLxN > hNSxugKhS6UOw/Wivbx0OIhN8jqBv4m22UgO9pFGgxHLs1hheSTMUSbExFCLuK+z > sS1Kw9syplk+lFTzK6mqNpr3BQ6v2fmkPmRTZoID4e9T3DY8Bna2JXG2U1QGEzwa > kwpJOMAvY3DDPv3pIK8= > =i8FY > -----END PGP SIGNATURE----- > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- There’s no obfuscated Perl contest because it’s pointless. —Jeff Polk Maranatha! <>< John McKown