oops, screwed up the mailing list address
> -----Original Message-----
> From: Henshall, Stuart - WCP
> Sent: Wednesday, July 18, 2001 9:06 AM
> To: 'ejt(at)cyno(dot)co(dot)uk'
> Cc: 'psql-odbc(at)postgresql(dot)org'
> Subject: RE: Data export using Microsoft Access
>
> Hello,
> If you use "<TableName>" then PostgreSQL is case sensitive. If you
> use <TableName> it rounds it down to lower case. One way I've used for
> converting tables from pg to access is to have a pg friendly tabel
> definition (all names lower case, no spaces or punctution bar _) and then
> have Access Queries (similar to PostgreSQL views) acting in place of the
> old
> tables, using AS to convert field names eg:
> SELECT field_pg AS [ANAccess / field] FROM table_pg
> (NB. try to avoid using pg at the start of PostgreSQL tables, used for
> system tables).
> hopt this helps,
> - Stuart
> (Sorry if this is wrongly addressed as the mail digest sometimes contains
> character sets my Outlook doesn't recognise and therefore just gives me
> one
> big text file)
>
> ORIGINAL MESSAGE:
> Hi,
>
> I am using the Postgres ODBC driver (version 7.01.00.05) to export tables
> from Access 2000 to PostgreSQL 7.0.2 on Linux. The problem is that all
> tables and attributes that contain upper case letters are only accessible
> on
> the new DB when enclosed in quotes, for example, a table called Test
> cannot
> be accessed using "select * from Test where Val = 3", it has to be
> rewritten
> as "select * from "Test" where "Val" = 3". It can be renamed using "alter
> table "Test" rename to Test" but obviously if there is a fix or workaround
> for this problem that would be better.
>
> As there are no errors generated I have not attached the log files, as far
> as both packages are concerned, everything is working fine.
>
> Thanks,
>
> Edward Thomas