From: | Tim <timfosho(at)gmail(dot)com> |
---|---|
To: | Paul Smith <paul(at)pscs(dot)co(dot)uk> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Creating redwood datestyle in Postgres 12 |
Date: | 2021-03-26 12:24:37 |
Message-ID: | CAKhLO5iqHP2YtNW+a5UVZoXC7M7xy=BUd3oZs1UD00fZzfhfhw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I suppose that would be possible, but maintaining date triggers + views
across a large database would be a lot of work. I'm just one humble DBA and
there is 15-20 devs
On Fri, Mar 26, 2021 at 5:21 AM Paul Smith <paul(at)pscs(dot)co(dot)uk> wrote:
> On 25/03/2021 12:38, Tim wrote:
> > Its a native ORACLE date formatting which shows like this: 08-JAN-99
> > 04:05:06 set in the datestyle config param.
> >
> > Currently running on EDB Advanced Server 12 which allows it as a
> > datestyle configuration setting, but looking to migrate off of there
> > to native postgres pretty soon and was hoping there was some way to
> > have the same setting globally in native postgres. Which is starting
> > to look like is not possible.
> Could you create views/rules/triggers to do the conversions for you?
>
> Eg, if you have a table 'invoices', then create a view 'invoices_' and
> set it to set your formatting, and use rules to allow updates/inserts
> via that view. That might need less changes to the code.
>
>
> --
> Paul
> Paul Smith Computer Services
> support(at)pscs(dot)co(dot)uk - 01484 855800
>
>
> --
>
>
> Paul Smith Computer Services
> Tel: 01484 855800
> Vat No: GB 685 6987 53
>
> Sign up for news & updates at http://www.pscs.co.uk/go/subscribe
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2021-03-26 12:35:55 | Re: Creating redwood datestyle in Postgres 12 |
Previous Message | Julien Rouhaud | 2021-03-26 11:25:28 | Re: Old query lying around in pg_stat_activity for weeks |