On Wednesday 09 Mar 2005 11:57 am, Tom Lane wrote: > Kenneth Gonsalves <[EMAIL PROTECTED]> 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.
postgresql 7.4. when i type: alter database set datestyle to 'European' i get 'syntax error at or near "datestyle" at character 20' -- regards kg http://www.livejournal.com/users/lawgon tally ho! http://avsap.sourceforge.net àààààààààà ààààà! ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
