Re: BUG #5167: Alternative to USE of MSSQL - Mailing list pgsql-bugs

From Devrim GÜNDÜZ
Subject Re: BUG #5167: Alternative to USE of MSSQL
Date
Msg-id 1257420454.6861.33.camel@hp-laptop2.gunduz.org
Whole thread Raw
In response to BUG #5167: Alternative to USE of MSSQL  ("forbiddenvk" <for.bid.den.vk@gmail.com>)
List pgsql-bugs
On Thu, 2009-11-05 at 06:01 +0000, forbiddenvk wrote:
> Why couldn't create a  alternative to USE command in MSSQL?, I think
> is
> necesary when we want execute a full script for create a database and
> tables
> in once.

(This is not a bug, but still...)

You can use psql's \c while scripting those kind of things.

Instead of using

USE dbname;

you can use this one:

\c dbname

and let psql read your script.
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: BUG #5167: Alternative to USE of MSSQL
Next
From: tomas@tuxteam.de
Date:
Subject: Re: BUG #5168: cannot login to server