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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
