Re: Auto-formatting timestamps? - Mailing list pgsql-sql

From Alvaro Herrera
Subject Re: Auto-formatting timestamps?
Date
Msg-id 20080514155936.GK5521@alvh.no-ip.org
Whole thread Raw
In response to Re: Auto-formatting timestamps?  ("Peter Koczan" <pjkoczan@gmail.com>)
List pgsql-sql
Peter Koczan escribió:
> On Tue, May 13, 2008 at 5:54 PM, Mag Gam <magawake@gmail.com> wrote:
> > Why not create a view?
> 
> That's a possibility, but the issue is that the output formatting is
> bound to a data type (timestamp), not one or two particular tables.
> Trying to create a view for all the tables with timestamps (and
> creating appropriate rules for updating views) would be a huge
> administrative PITA.

If you're really set about that, you can add a new DateStyle setting.
It's a bit of C hacking.  (Or you can hire someone to do it for you.)

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-sql by date:

Previous
From: "Peter Koczan"
Date:
Subject: Re: Auto-formatting timestamps?
Next
From: "Mag Gam"
Date:
Subject: Re: Auto-formatting timestamps?