From: | "Martijn Tonies \(Upscene Productions\)" <m(dot)tonies(at)upscene(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Why is table not found? |
Date: | 2017-01-31 13:50:40 |
Message-ID: | 9099071BBFD34A7DBB6023DBECB6E11E@MARTIJNWS |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello Egon,
You created the table using delimited identifiers:
"Raum"
which is not the same as
Raum of raum or RAUM
When you use delimited identifiers (eg: "MyTable" instead of MyTable), the
name becomes case sensitive.
When you use SQL, you need to use delimited identifiers:
select * from "Raum"
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.
-----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;
> ^
> Hausrat=#
Why?
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(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Rob Sargent | 2017-01-31 13:52:51 | Re: Why is table not found? |
Previous Message | Raymond O'Donnell | 2017-01-31 13:49:33 | Re: Why is table not found? |