On Friday 18 January 2008 14:38, Steve Clark wrote: > Thanks for everyone that replied to my query about pg_dumpall. > > > Now another question/issue - anytime I usr createdb the resulting db > ends up > with UTF-8 encoding unless I use the -E switch. Is there a way to make > the > default be sql_ascii? postgres version is 8.2.5 > > Thanks again > Steve
Hi Steve, http://www.postgresql.org/docs/8.2/static/app-initdb.html Best regards, -- Aarni ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
