Re: Why is table not found?

["Raymond O'Donnell" <rod@xxxxxx>]

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