double quotes around column names in postgresql sample db

[GoogleCodeExporter]

What steps will reproduce the problem?
1. in postgresql, any "normal" select command, such as 
SELECT * FROM Customers WHERE City LIKE '%lin%'; 
will throw an error.

What is the expected output? What do you see instead?

expect matching db rows

displays error:
northwind=#ERROR:  column "City" does not exist
LINE 1: select City from public.customers;

What version of the product are you using? On what operating system?

 select version();
                                                   version                                                    
--------------------------------------------------------------------------------
------------------------------
 PostgreSQL 9.3.2 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
(1 row)

Please provide any additional information below.

You could change the query to include quotes around the col names, but I saw 
that as a pain in the long run, and it's not normal for postgresql syntax 
(imho). I used vi to edit out the double quotes in two steps from the .sql 
file.  The .sql file is in three general sections, table creation, data insert, 
and constraint creation. I did a global change from line 1 to line 280, the 
create table section, changing the " character to null.  There are " characters 
in the data in insert, so down below I repeated the change for the constraints 
that get added after the inserts starting at line 3736.

I've attached the edited version to this issue.

Original issue reported on code.google.com by ray.st...@gmail.com on 15 Apr 2014 at 9:06

Attachments:

• northwind.postgre.noquote.sql