Subject: Re: Creating redwood datestyle in Postgres 12
To: pgsql-admin@lists.postgresql.org
References: 
 <CAKhLO5jDy8bMop66WU8cNUFcfSuL1==FyGvawKZT-CC2FYuZXQ@mail.gmail.com>
 <5273bd68ae53e76fb592249ba05433b4bb645660.camel@cybertec.at>
 <CAKhLO5i-PJdeX2q8eEzYVs91bzw1bDJxaSL_tD96XhnmGVAJfg@mail.gmail.com>
From: Paul Smith <paul@pscs.co.uk>
Message-ID: <d31d1a49-2394-e18b-f810-0a2832826f34@pscs.co.uk>
Date: Fri, 26 Mar 2021 09:16:00 +0000
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0)
 Gecko/20100101 Thunderbird/78.8.0
MIME-Version: 1.0
In-Reply-To: 
 <CAKhLO5i-PJdeX2q8eEzYVs91bzw1bDJxaSL_tD96XhnmGVAJfg@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-GB
Archived-At: 
 <https://www.postgresql.org/message-id/d31d1a49-2394-e18b-f810-0a2832826f34%40pscs.co.uk>
Precedence: bulk

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@pscs.co.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