Which is the criteria for defining " as mandatory or not in a Postgresql query?

Posted by user193655 on Stack Overflow See other posts from Stack Overflow or by user193655
Published on 2010-06-18T14:30:53Z Indexed on 2010/06/18 14:33 UTC
Read the original article Hit count: 221

Filed under:
|

I am getting started with Postgresql, I converted a MS SQL DB but I cannot understand why

SELECT * FROM TABLE doens't work

while

SELECT * FROM "TABLE" does

Moreover from another machine, connecting to the same DB I can run

SELECT * FROM TABLE (without ")

It's a PG-newbie question, I hope you can help.

© Stack Overflow or respective owner

Related posts about sql

Related posts about postgresql