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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
