From: | Paul Smith <paul(at)pscs(dot)co(dot)uk> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Creating redwood datestyle in Postgres 12 |
Date: | 2021-03-26 09:16:00 |
Message-ID: | d31d1a49-2394-e18b-f810-0a2832826f34@pscs.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 | Jacque Edmund | 2021-03-26 11:16:42 | Old query lying around in pg_stat_activity for weeks |
Previous Message | Pepe TD Vo | 2021-03-25 21:00:08 | create and drop tablespace |