Question: how to properly set datestyle on pooled connections

[bydga]

When using the pool.connect & client.release approach, I'm setting the set datestyle = iso mdy as a first query to have my date-types parsed properly.

However, how to do it with the pool.query call? Since the connection returned is random - and might be an existing one recently returned to the pool as well as a newly established one..

Im not sure, if setting pg.types.setTypeParser for all the date/datetime/timestamp with/without timezone is a way I want to go..

Suggestions? :)

[charmander]

You can create a client type for use with the pool providing custom startup configuration:

const pool = new pg.Pool({
    Client: class extends pg.Client {
        getStartupConf() {
            return Object.assign(super.getStartupConf(), {
                DateStyle: 'ISO,MDY',
            });
        }
    },
    ⋮
});

It might be nice to have an option along these lines, though:

class pool = new pg.Pool({
    connectionOptions: {
        DateStyle: 'ISO,MDY',
    },
    ⋮
});

[bydga]

hm, i've solved it by doing

pool.on "connect", (client) ->
    client.query "SET DATESTYLE = iso, mdy"

but your solution looks better :)

[brianc]

I added this to the documentation