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/
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/law
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 char
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 databas
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
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
