psqlpy icon indicating copy to clipboard operation
psqlpy copied to clipboard

How to use SET statements?

Open kesavkolla opened this issue 11 months ago • 1 comments
trafficstars

Postgres allow to add SET statements to set some parameters.

Eg: SET datestyle TO postgres, dmy; SET TIME ZONE 'America/Los_Angeles';

How can use these SET statements as part of executing query?

Eg: I would like to run this

SET TIME ZON 'America/Los_Angeles'; SELECT NOW()

Execute batch is not returning results so can't use executeBatch method. Is there any way to achieve this?

kesavkolla avatar Nov 22 '24 10:11 kesavkolla