1) I believe there is an ODBC option to hide the OID column. Also, I think
I read that 7.2 will have an option to create tables without OID's.
2) 2001-11-20 2:00:00PM (yyyy-mm-dd hh:ss:mmAM)
----- Original Message -----
From: "Helen M Hudson" <helen(at)rttc(dot)co(dot)za>
Sent: Monday, November 19, 2001 1:51 PM
Subject: 2 newbie questions
> 1. I'm porting a clients database over from access(!). In order not to
> 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
> "getting rid of the oid column" was a possibility?
> 2. I have a date/time column in access... should this datatype be datetime
> in postgres... and how do i format the text to import it into the postgres
> file using copy?
> All replies humbly appreciated! :)
In response to
pgsql-novice by date
|Next:||From: Francisco Reyes||Date: 2001-11-20 15:17:33|
|Subject: If function available?|
|Previous:||From: Mark Hesketh||Date: 2001-11-20 12:58:33|
|Subject: Trouble with MS Access-to-postgresql export|