Postgres Pro
Downloads
Home   >   mailing lists

best type for unix file system timestamp? - Mailing list pgsql-general

From Mark Harrison
Subject best type for unix file system timestamp?
Date
Msg-id 410AB8B8.9040306@pixar.com
Whole thread Raw
Responses Re: best type for unix file system timestamp?  ("Glen Parker" <glenebob@nwlink.com>)
Re: best type for unix file system timestamp?  (jseymour@linxnet.com (Jim Seymour))
List pgsql-general
Tree view 
So, I'm recording the timestamp from some unix files.

Any opinions as to whether it's best to use a "bigint"
(which matches the file system data) or a "timestamp"
(which might be easier to manipulate in the database)?

TIA!
Mark

--
Mark Harrison
Pixar Animation Studios

pgsql-general by date:

Previous
From: "Jason Tesser"
Date:
Subject: Re: Backup questions
Next
From: "Glen Parker"
Date:
Subject: Re: best type for unix file system timestamp?