From: | SAKAIDA Masaaki <sakaida(at)psn(dot)co(dot)jp> |
---|---|
To: | hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] pgbash-1.1.1 release |
Date: | 1999-10-01 14:08:10 |
Message-ID: | 37F4C04A1B8.A39FSAKAIDA@smtp.psn.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-interfaces |
Oleg Bartunov <oleg(at)sai(dot)msu(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 1999-10-01 14:54:45 | Re: [HACKERS] Re: TO_CHAR() |
Previous Message | Oleg Bartunov | 1999-10-01 12:12:29 | problem compiling current sources with gcc 2.95.1 |
From | Date | Subject | |
---|---|---|---|
Next Message | jose soares | 1999-10-01 15:14:33 | Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized? |
Previous Message | Oleg Bartunov | 1999-10-01 11:38:11 | Re: [HACKERS] pgbash-1.1.1 release |