Re: 2 newbie questions

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)

--rob

----- Original Message -----
From: "Helen M Hudson" <helen(at)rttc(dot)co(dot)za>
To: <pgsql-novice(at)postgresql(dot)org>
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
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?
>
> 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! :)
>
> Helen
>
>