search

MaxMorais / northwindextended

Automatically exported from code.google.com/p/northwindextended
0 stars 0 forks source link

quote signs on field names are not necessary! #5

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
The quote signs on field names are not necessary - in fact -they come in the 
way!
the script as is - create field names like '"OrderID"' instead of 'OrderId'

What steps will reproduce the problem?
1. created db
2. ran the script as is
3. query: SELECT OrderID FROM orders;

Expected: recordset with 1 column

FOUND: error column OrderID does not exist.

For evidence, when querying SELECT "OrderID" FROM orders; - it works...

Tried on Posgtgres v9.3+154

Original issue reported on code.google.com by LarisaYa...@gmail.com on 24 Jan 2015 at 11:53