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, whole thread or download thread mbox)
Lists: pgsql-odbc

I am using the Postgres ODBC driver (version 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.


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:  |  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-2017 The PostgreSQL Global Development Group