At 01:55 PM 4/23/05, Tadej Kanizar wrote:
Ok, so I installed the latest version of Postresql (8.02) on a WinXP SP2 machine..
My question is why won't the statement SELECT * FROM table work, whereas the statement SELECT * FROM »table« works!
And, to explain a bit more, here's another example:
INSERT INTO TestTable (Name, Surname) VALUES ('name', 'surname'); .. this DOESN'T work
INSERT INTO »TestTable« (»Name«, »Surname«) VALUES ('name', 'surname'); .. this DOES work
If you create a table using quotes and mixed-case, you will need quotes every time you reference the table. Don't use quotes when you create the table and you won't need them when you acces the table with other commands.
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
