Thread: datestyle setting
hi, 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'? -- regards kg http://www.livejournal.com/users/lawgon tally ho! http://avsap.sourceforge.net ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!
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
On Wednesday 09 Mar 2005 11:57 am, Tom Lane wrote: > 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. 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 ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!
Kenneth Gonsalves wrote: > On Wednesday 09 Mar 2005 11:57 am, Tom Lane wrote: >> >>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' I keep making this mistake, you need to include the database name: ALTER DATABASE my_db_name SET datestyle TO 'ISO'; -- Richard Huxton Archonet Ltd
On Wednesday 09 Mar 2005 1:40 pm, Richard Huxton wrote: > > I keep making this mistake, you need to include the database name: > ALTER DATABASE my_db_name SET datestyle TO 'ISO'; er ... doesnt seem to be in the docs? Anyway it worked, thanx -- regards kg http://www.livejournal.com/users/lawgon tally ho! http://avsap.sourceforge.net ಇಂಡ್ಲಿನಕ್ಸ வாழ்க!
Kenneth Gonsalves wrote: > On Wednesday 09 Mar 2005 1:40 pm, Richard Huxton wrote: > > >>I keep making this mistake, you need to include the database name: >> ALTER DATABASE my_db_name SET datestyle TO 'ISO'; > > > er ... doesnt seem to be in the docs? Anyway it worked, thanx http://www.postgresql.org/docs/7.4/static/sql-alterdatabase.html Synopsis ALTER DATABASE name SET parameter { TO | = } { value | DEFAULT } ALTER DATABASE name RESET parameter -- Richard Huxton Archonet Ltd