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

Re: 2 newbie questions

From: "Rob Arnold" <rob(at)cabrion(dot)com>
To: "Helen M Hudson" <helen(at)rttc(dot)co(dot)za>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: 2 newbie questions
Date: 2001-11-20 13:34:55
Message-ID: 000a01c171c8$38a463e0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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>
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
> 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! :)
> Helen

In response to

pgsql-novice by date

Next:From: Francisco ReyesDate: 2001-11-20 15:17:33
Subject: If function available?
Previous:From: Mark HeskethDate: 2001-11-20 12:58:33
Subject: Trouble with MS Access-to-postgresql export

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