Search Postgresql Archives

Re: Why is table not found?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux