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
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
