First, go to TechDocs (http://techdocs.postgresql.org/). There you will
find several articles and scripts for porting Access to PsotgreSQL.
Second, join pgsql-odbc mailing list, where you will find other users
running postgres with MS Access and VB front-ends.
> 1. I'm porting a clients database over from access(!). In order not
> to have
> to tamper with the code, I need to rid myself of the oid column. I
> have a
> workaround which involves editing the code, but I was just interested
> if the
> "getting rid of the oid column" was a possibility?
OID-less tables will become available in 7.2 (currently in beta).
However, as a developer who has one Access client app running on a
PostgreSQL back-end, I don't understand the problem that you are having
with OIDs. They have not been a concern for me.
> 2. I have a date/time column in access... should this datatype be
> in postgres... and how do i format the text to import it into the
> file using copy?
Several valid date/time formats should work. You'll have best luck with
the standard Unix format, that is "YYYY-MM-DD HH:MM:SS" (i.e.
______AGLIO DATABASE SOLUTIONS___________________________
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2001-11-19 20:46:47|
|Subject: Re: 7.1.3 compilation failure (libpq or aync?) |
|Previous:||From: Jason Earl||Date: 2001-11-19 20:17:24|
|Subject: Re: 2 newbie questions|