Thanks for the swift responses, I tried the \c command but I got the following error:
ERROR: syntax error at or near "\" SQL state: 42601 Character: 520 Here's a code snippet ... <snip> -- -- TOC entry 1685 (class 1262 OID 16453) -- Name: test_db; Type: DATABASE; Schema: -; Owner: postgres -- DROP DATABASE IF EXISTS test_db; CREATE DATABASE test_db WITH TEMPLATE = template0 ENCODING = 'UTF8'; ALTER DATABASE test_db OWNER TO postgres; \c test_db; -- query tool doesn't like this command :-( </snip> Rommel Edwards Software Developer, Barbados, Caribbean. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings