Re: Change Default Database

From: "Rommel the iCeMAn" <icecrew(at)gmail(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Change Default Database
Date: 2007-02-26 17:22:54
Message-ID: 008d01c759ca$c131a2f0$b364a8c0@theport.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Louis-David Mitterrand 2007-02-26 18:14:51 getting at sequence previous/next values
Previous Message Rodrigo De León 2007-02-26 17:09:24 Re: Change Default Database