How can I preserve timestamp for a set of data? I'm using PostgreSQL
8.02. I had to do a dump of my database and then at a later date I
imported the data I had in several tables. Here's an example:
yw_id weight yarnweight_lud
1 Cobweb 2005-01-13 15:21:50.654149
2 Lace Weight 2005-01-13 15:21:50.654149
3 Sock 2005-01-13 15:21:50.654149
When I use the import wizard for Aqua Data Studio, it sets all values
for yarnweight_lud to NULL.
I can create insert queries for all of these if I have to but I need to
know how to force preservation of the time stamp.
Lola - mailto:lola(at)his(dot)com
http://www.lolajl.net | Blog at http://www.lolajl.net/blog/
Terrorismus delendus est! (Terrorism must be destroyed utterly!)
I'm in Bowie, MD, USA, halfway between DC and Annapolis.
pgsql-novice by date
|Next:||From: Keith Worthington||Date: 2005-07-16 12:40:34|
|Subject: Re: User Context Variables|
|Previous:||From: Jaime Casanova||Date: 2005-07-15 22:19:01|
|Subject: Re: plpgsql trigger problem|