Re: [GENERAL] newbie Connect question - Mailing list pgsql-general

From Jim Richards
Subject Re: [GENERAL] newbie Connect question
Date
Msg-id 199909030043.UAA33013@hub.org
Whole thread Raw
In response to newbie Connect question  ("Phil Oelkers" <Phil.Oelkers@experian.com>)
List pgsql-general
At 05:07  1/09/99 -0500, Phil Oelkers wrote:
>I'm trying to run the following script through interactive postgres.
>
>CONNECT DATABASE BASEBALL;

The correct way to connect to another database within psql is

\connect baseball

but you need to be careful then which user you are attched to. Unlike
Oracle, all users can do DML (CREATE, etc) across all databases, unless
you have specifically set up your security, which is something I'm trying
to work out ...


----
CyberCyberCyberCyber Pty Ltd
 http://www.cyber4.org/cyber4/index.html
  New Media For The New Millennium

pgsql-general by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: [GENERAL] Accounting/inventory systems
Next
From: "freetips"
Date:
Subject: Wingate for Linux