Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 7F7231810A00
	for <pgsql-sql@postgresql.org>; Fri,  2 Mar 2012 12:56:16 -0400 (AST)
Received: from oldperseverance.encs.concordia.ca ([132.205.96.94])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <emilu@encs.concordia.ca>) id 1S3VmA-0005uF-IU
	for pgsql-sql@postgresql.org; Fri, 02 Mar 2012 16:56:15 +0000
Received: from cacao.encs.concordia.ca (emilu@cacao.encs.concordia.ca
	[132.205.47.225]) by oldperseverance.encs.concordia.ca (envelope-from
	emilu@encs.concordia.ca) (8.13.7/8.13.7) with ESMTP id
	q22Gu01G006207; Fri, 2 Mar 2012 11:56:00 -0500
Message-ID: <4F50FBA0.3070808@encs.concordia.ca>
Date: Fri, 02 Mar 2012 11:56:00 -0500
From: Emi Lu <emilu@encs.concordia.ca>
Reply-To: emilu@encs.concordia.ca
User-Agent: Mozilla/5.0 (X11; Linux i686;
	rv:10.0) Gecko/20120129 Thunderbird/10.0
MIME-Version: 1.0
To: Adrian Klaver <adrian.klaver@gmail.com>
CC: Carlos Mennens <carlos.mennens@gmail.com>,
	"PostgreSQL (SQL)" <pgsql-sql@postgresql.org>
Subject: Re: Change Ownership Recursively
References: 
 <CAAQLLO7gqap3zYUGGd0fuTZjS8OWt86OUtvNQubLEGf40AyNfA@mail.gmail.com>
	<4F4FA622.70002@affinitas.de>
	<CAAQLLO7W6pAKz26k=JV8W_47O+DT6kOf--U3QKkmgXq_s7LfMw@mail.gmail.com>
	<4F4FC1A1.6070702@gmail.com>
	<CAAQLLO5j9N4FACujBrsnz+aYVV4mYHa8f1TgmLP16AX97Z7qrg@mail.gmail.com>
	<4F4FD1AD.90501@gmail.com>
In-Reply-To: <4F4FD1AD.90501@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Scanned-By: MIMEDefang 2.58 on oldperseverance.encs.concordia.ca at
	2012/03/02 11:56:00 EST
X-Pg-Spam-Score: -4.2 (----)
X-Archive-Number: 201203/19
X-Sequence-Number: 36414



> iamunix=# \c postgres
>
> was really meant to be:
>
> iamunix=# \c - postgres
>
> The first changes to database postgres as current user, the second
> changes the user while remaining on the current database.

This is very helpful!

psql> \c - username_for_new_connection

--
Emi