quoting facilities set up so that database-specific quoting can be

turned on for individual table, schema, and column identifiers when
used in all queries/creates/drops.  Enabled via "quote=True" in
Table or Column, as well as "quote_schema=True" in Table.  Thanks to
Aaron Spike for his excellent efforts.  [ticket:155]

1 files changed, 7 insertions, 1 deletions

diff --git a/lib/sqlalchemy/databases/postgres.py b/lib/sqlalchemy/databases/postgres.py
index 8368c8931..4efe0e162 100644
--- a/lib/sqlalchemy/databases/postgres.py
+++ b/lib/sqlalchemy/databases/postgres.py
@@ -245,6 +245,8 @@ class PGDialect(ansisql.ANSIDialect):
         return PGSchemaDropper(*args, **kwargs)
     def defaultrunner(self, engine, proxy):
         return PGDefaultRunner(engine, proxy)
+    def preparer(self):
+        return PGIdentifierPreparer()
         
     def get_default_schema_name(self, connection):
         if not hasattr(self, '_default_schema_name'):
@@ -331,7 +333,7 @@ class PGCompiler(ansisql.ANSICompiler):
 class PGSchemaGenerator(ansisql.ANSISchemaGenerator):
         
     def get_column_specification(self, column, **kwargs):
-        colspec = column.name
+        colspec = self.preparer.format_column(column)
         if column.primary_key and not column.foreign_key and isinstance(column.type, sqltypes.Integer) and (column.default is None or (isinstance(column.default, schema.Sequence) and column.default.optional)):
             colspec += " SERIAL"
         else:
@@ -382,4 +384,8 @@ class PGDefaultRunner(ansisql.ANSIDefaultRunner):
         else:
             return None
 
+class PGIdentifierPreparer(ansisql.ANSIIdentifierPreparer):
+    def _fold_identifier_case(self, value):
+        return value.lower()
+
 dialect = PGDialect