Skip site navigation (1) Skip section navigation (2)

Data export using Microsoft Access

From: "Edward Thomas" <ejt(at)cyno(dot)co(dot)uk>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Data export using Microsoft Access
Date: 2001-07-11 13:19:41
Message-ID: 060801c10a0c$38b42560$0300a8c0@Yoda (view raw or flat)
Thread:
Lists: pgsql-odbc
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

--
CYNOSURE - Internet strategy and production

t: 01224 355271    |  CYNOSURE
f: 01224 626227    |  The Software Centre, Campus 2
e: ejt(at)cyno(dot)co(dot)uk  |  Aberdeen Science and Technology Park
w: www.cyno.co.uk  |  Aberdeen, AB22 8GU


pgsql-odbc by date

Next:From: Tom LaneDate: 2001-07-11 15:21:35
Subject: Re: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found
Previous:From: pgsql-bugsDate: 2001-07-11 00:34:33
Subject: ERROR: deferredTriggerGetPreviousEvent: event for tuple (0,9) not found

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group