Re: Change Default Database - Mailing list pgsql-sql

From Rommel the iCeMAn
Subject Re: Change Default Database
Date
Msg-id 008d01c759ca$c131a2f0$b364a8c0@theport.com
Whole thread Raw
In response to Re: Change Default Database  ("Rodrigo De León" <rdeleonp@gmail.com>)
Responses Re: Change Default Database
List 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.



pgsql-sql by date:

Previous
From: "Rodrigo De León"
Date:
Subject: Re: Change Default Database
Next
From: Louis-David Mitterrand
Date:
Subject: getting at sequence previous/next values