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
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
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
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
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
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