Обсуждение: BUG #5167: Alternative to USE of MSSQL

The following bug has been logged online:

Bug reference:      5167
Logged by:          forbiddenvk
Email address:      for.bid.den.vk@gmail.com
PostgreSQL version: 8.4
Operating system:   Windows
Description:        Alternative to USE of MSSQL
Details:

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.

forbiddenvk wrote:
> The following bug has been logged online:
>
> Bug reference:      5167
> Logged by:          forbiddenvk
> Email address:      for.bid.den.vk@gmail.com
> PostgreSQL version: 8.4
> Operating system:   Windows
> Description:        Alternative to USE of MSSQL
> Details:
>
> 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.
>
>

psql has the \c command to connect to a database.  this can be embedded
in a SQL file thats executed by psql

2009/11/5 forbiddenvk <for.bid.den.vk@gmail.com>:
>
> The following bug has been logged online:
>
> Bug reference: =C2=A0 =C2=A0 =C2=A05167
> Logged by: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0forbiddenvk
> Email address: =C2=A0 =C2=A0 =C2=A0for.bid.den.vk@gmail.com
> PostgreSQL version: 8.4
> Operating system: =C2=A0 Windows
> Description: =C2=A0 =C2=A0 =C2=A0 =C2=A0Alternative to USE of MSSQL
> Details:
>
> Why couldn't create a =C2=A0alternative to USE command in MSSQL?, I think=
 is
> necesary when we want execute a full script for create a database and tab=
les
> in once.

Hello

\c command is alternative of USE statement in MSSQL.

postgres=3D# \c template1
You are now connected to database "template1".
template1=3D#

regards
Pavel Stehule

>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/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