Date: Fri, 01 Oct 1999 23:08:10 +0900
From: SAKAIDA Masaaki <sakaida@psn.co.jp>
To: hackers@postgreSQL.org
Subject: Re: [HACKERS] pgbash-1.1.1 release
In-Reply-To: <Pine.GSO.3.96.SK.991001153404.16613a-100000@ra>
References: <37F46FD92D0.D25FSAKAIDA@smtp.psn.ne.jp>
	<Pine.GSO.3.96.SK.991001153404.16613a-100000@ra>
Message-Id: <37F4C04A1B8.A39FSAKAIDA@smtp.psn.ne.jp>
MIME-Version: 1.0
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 7bit


Oleg Bartunov <oleg@sai.msu.su>  wrote:
> That's really cool !

  Thank you.

> I just install and played a little bit.
> I found a minor problem :
> I have to connect to any database to issue
> exec_sql -l database
> I have no my personal database
> Here is a log:
> 
> bash-2.03$ exec_sql -l database
> (-402)FATAL 1:  Database megera does not exist in pg_database

  If CONNECT have not been executed yet, "CONNECT TO DEFAULT" 
will be automatically issued when -l option is executed.

  If user name is "megera", then "CONNECT TO DEFAULT" is equal
to "CONNECT TO megera USER megera". 


> bash-2.03$ exec_sql "connect to discovery"
> # PostgreSQL 6.5.2 on i586-pc-linux-gnulibc1, compiled by gcc 2.95.1
> # CONNECT TO  discovery:5432  AS  discovery  USER  megera
> 
> bash-2.03$ exec_sql -l database
> # Databases list
> 
> datname  |datdba|encoding|datpath  
> ---------+------+--------+---------
> template1|   505|      16|template1
> apod     |    11|      16|apod     
> 
> I don't understand this requirements just to list all databases

  This approach is equal to psql.  

# However, I consider that "CONNECT TO template1" may be better 
  than "CONNECT TO <User_naame>" in the case of "-l database".


--
Regard.

SAKAIDA Masaaki -- Osaka, Japan
# Sorry, I am not good at English.