Re: datestyle setting - Mailing list pgsql-sql

From Tom Lane
Subject Re: datestyle setting
Date
Msg-id 20765.1110349646@sss.pgh.pa.us
Whole thread Raw
In response to datestyle setting  (Kenneth Gonsalves <lawgon@thenilgiris.com>)
Responses Re: datestyle setting  (Kenneth Gonsalves <lawgon@thenilgiris.com>)
List pgsql-sql
Kenneth Gonsalves <lawgon@thenilgiris.com> writes:
> i have a website with a postgresql backend. Being a shared site, i 
> have no root access. i do have shell access to the database, but 
> cannot create or drop the database. I access the database through 
> python scripts using the psycopg adapter. My question is, how do i 
> set the pgdatestyle in the database as 'European,sql'?

If it's a reasonably recent version of PG, either ALTER DATABASE SET
or ALTER USER SET might serve.
        regards, tom lane


pgsql-sql by date:

Previous
From: Kenneth Gonsalves
Date:
Subject: datestyle setting
Next
From: Kenneth Gonsalves
Date:
Subject: Re: datestyle setting