Re: [SQL] Determining the DATE format with libpq - Mailing list pgsql-sql

Whoooooo that's perfect!!!

I hope it has not a big cost?

Can I use this each time I fetch a result set?

Even row by row with a server cursor?

Seb

On 08/24/2017 05:26 PM, Tom Lane wrote:
> Sebastien FLAESCH <sf@4js.com> writes:
>> Is there a way to know the current date format used in the SQL session?
>> Ideally, we expect a libpq API.
>
> Use PQparameterStatus().
>
>> We cannot do a "SHOW DateStyle" each time we executing a SELECT!
>
> You don't have to --- the server automatically reports changes in the
> value of that parameter.
>
>             regards, tom lane
>
>