Found one setting "standard_conforming_strings", which according to a Blog post is the right one.
Default value is Off, if I set it to On it breaks other bits...
2009-09-15 14:21:02 ESTERROR: unterminated quoted string at or near "'::character varying,1,2,3,4) ORDER BY id" at character 47
2009-09-15 14:21:02 ESTSTATEMENT: SELECT * FROM mdl_hotpot_strings WHERE id IN ('::character varying,1,2,3,4) ORDER BY id
2009-09-15 14:25:51 ESTERROR: syntax error at or near "RI" at character 244
2009-09-15 14:25:51 ESTSTATEMENT: INSERT INTO mdl_question_categories ( ID, NAME, CONTEXTID, INFO, STAMP, PARENT, SORTORDER ) VALUES ( 4, 'Default for RI - 01/09 - AUR30405 Certificate III in Automotive Technology', 187, 'The default category for questions shared in context \'RI - 01/09 - AUR30405 Certificate III in Automotive Technology\'.', 'devlearnonline.rit.tafensw.edu.au+090217050337+n8rPg2', 0, 999 )
There is also talk of "standard_conforming_strings" having a default setting of On in the near future, that maybe something to look forward to...
Do you know of any step by step instruction for Moodle using PostgreSQL.
I have found heaps on MYSQL, some for MSSQL but none for PostgreSQL...