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
> 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
> 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
> big text file)
> ORIGINAL MESSAGE:
> 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
> the new DB when enclosed in quotes, for example, a table called Test
> be accessed using "select * from Test where Val = 3", it has to be
> 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.
> Edward Thomas
pgsql-odbc by date
|Next:||From: Henshall, Stuart - WCP||Date: 2001-07-18 08:37:08|
|Subject: RE: Access 97, Error - Data changed by another user, Copy to Clipboard or Drop changes|
|Previous:||From: Joseph||Date: 2001-07-17 17:58:18|
|Subject: Access 97, Error - Data changed by another user, Copy to Clipboard or Drop changes|