I am migrating our database from ingres to postgres and I want a replica of ingres database into postgres for this I had to write a lot of scripts but I don't know how to take care of this problem as postgres this by default.When I retrieve it with a select query it comes with ZONE but you are right may be the programmers would be able to do whatever they want without any problem.Thanks anyway !
Nimesh ----- Original Message ----- From: "Mark McEahern" <[EMAIL PROTECTED]> To: "nimeshb" <[EMAIL PROTECTED]>; "Brian McCane" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, June 20, 2002 10:54 AM Subject: Re: [ADMIN] time stamp > > CREATE TABLE test (ts TIMESTAMP WITHOUT TIME ZONE) ; doesn't work. It > > creates that table but > > when you insert a value without time zone it stll appends -05 as time > > zone(my datestyle is US and since my time is EST it appends 05 on its own > > and that sucks ) > > Why do you care how pg stores the field? Are you able to retrieve it and do > the stuff you need to do? > > // m > > - > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
