Re: Change Default Database - Mailing list pgsql-sql

From Rodrigo De León
Subject Re: Change Default Database
Date
Msg-id a55915760702261043s5c52101cqa3e8dd07b5d6f348@mail.gmail.com
Whole thread Raw
In response to Re: Change Default Database  ("Rommel the iCeMAn" <icecrew@gmail.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Louis-David Mitterrand
Date:
Subject: getting at sequence previous/next values
Next
From: Scott Marlowe
Date:
Subject: Re: Change Default Database