Re: Change Ownership Recursively

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>, "PostgreSQL (SQL)" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Change Ownership Recursively
Date: 2012-03-02 16:56:00
Message-ID: 4F50FBA0.3070808@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Sandeep Reddy 2012-03-02 19:41:31 Re: Problems with ODBC connections
Previous Message Mario Marín 2012-03-02 12:29:26 Re: How to shrink database in postgresql