On 2/26/07, Rommel the iCeMAn <icecrew@gmail.com> wrote:
> Hi list,
>
> I wrote a database creation script that begins with commands to drop the
> existing database (if it exists) and create it from scratch. These commands
> execute fine, the problem is that all subsequent commands are executed on
> the default database 'postgres'. What command can I use to set the default
> database to my newly created database (for the duration of the script)? SQL
> Server has a 'USE [dbname]' command, is there an equivalent command in
> PostgreSQL?
>
> Thanks in advance,
>
> Rommel Edwards
> Software Developer,
> Barbados, Caribbean.

If using psql:

\c dbname

then the rest of the commands.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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

On 2/26/07, Rommel the iCeMAn <icecrew@gmail.com> wrote:
> 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.

\c only works in psql.

See:
http://www.postgresql.org/docs/8.2/static/app-psql.html

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate