"Gloria W" <strangest(at)comcast(dot)net> writes:
> ERROR: invalid input syntax for type timestamp with time zone: "2006-03-20
> 09:06:00 US/Pacific"
That is not currently supported, sorry. Timestamp input can only use
the timezone names known to the "date token table", which basically
is the short abbreviations like PST. It'll get fixed eventually but
it's a feature enhancement not a bug.
regards, tom lane