Timestamp accuracy

Hi,

The user manual said the Timestamp type has a microsecond accuracy, but how can
I display the results of a query with microseconds ? 
Without formatting the output has an accuracy of 10^-2 second, and with
formatting it is even worse since the formatting strings do not accept anything
under the second.

SQL example:
    > create table test_ts (ts timestamp);    > insert into test_ts values ('2001-2-2 00:00:00.123456789');    > select
*from test_ts;
 
          ts                ---------------------------   2001-02-02 00:00:00.12+01

Florian