[GENERAL] Why is table not found?

-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

Re: [GENERAL] Why is table not found?

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: > > > -- T

[GENERAL] Query with type char

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Why are there 0 rows? I expect 3 rows: > mydb=# SELECT * FROM sample_char; > sp1 | sp2 | sp3 > -+-+- >1 | Bremen | >2 | Hamburg | >4 | Toronto | >3 | Bern| j >

[GENERAL] How tö select a column?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a table with two columns with type money. If column 'a' has an amount > 0 then this amount is wanted else the amount from column 'b'. How could I do this? Thanks. Egon -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.22 (GNU/Linux) iQIcB