Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: case sensitivity on table & column names / workaround?
- From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
- To: postgresql(dot)org(at)tgice(dot)com
- Cc: pgsql-odbc(at)postgresql(dot)org
- Subject: Re: case sensitivity on table & column names / workaround?
- Date: Fri, 16 Jun 2006 10:18:45 +0200
> 1) Change *all* of my present and future PG code for this database (that > touches the MSSQL tables, at least) to always surround table & column > names with double quotes. > > 2) Figure out a way to get MSSQL or the PG ODBC driver to drop or ignore > those double quotes on the SQL coming from the replication process. > > 3) Figure out a way for PG to modify its behavior and allow > non-double-quoted identifiers to match ones that were originally double > quoted. What about updateable views? It could be the way for replication and name changing. I'm not sure it's only an idea. Regards, Luf
- Follow-Ups:
- Re: case sensitivity on table & column names / workaround?
- From: postgresql . org
- Re: case sensitivity on table & column names / workaround?
- References:
- case sensitivity on table & column names / workaround?
- From: postgresql . org
- case sensitivity on table & column names / workaround?
- Prev by Date: Re: Memory Leak ?
- Next by Date: Re: Memory Leak ?
- Previous by thread: Re: case sensitivity on table & column names / workaround?
- Next by thread: Re: case sensitivity on table & column names / workaround?
- Indexes: