Thank you all for your answers.
You see: it is a newbie question.
Egon
Am 31.01.2017 um 14:45 schrieb Egon Frerich:
>
> 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";
>
> > CREAT
> On 31 Jan 2017, at 14:45, Egon Frerich wrote:
>>
>> CREATE TABLE "Raum"
>> (
>> "RaumID" serial NOT NULL, -- Automatisch vergebenes
> But psql tells me "Raum" is not existent:
>
>> egon@xfEinzel ~ $ psql Hausrat
>> psql (9.3.15)
>> Type "help" for help.
>>
>> Hausrat=# SELECT * FROM Raum;
On Tue, Jan 31, 2017 at 7:45 AM, 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
You must quite as "Raum"
> On Jan 31, 2017, at 6:45 AM, 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 "R
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
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, -- Au
-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
Identifiz