According to the docs, the PostgreSQL TIMESTAMP is accurate to microseconds. But the typical display only goes to centiseconds. Java and Unix timestamps generally go to milliseconds.
Is there a way to get Postgresql 7.1 to report times with higher resolution? As it is, when you store a timestamp via JDBC, you won't get back the same time you put in because it's missing that last digit of resolution.