Thread: PostgreSQL DataBase Manager

PostgreSQL DataBase Manager

From
"Denis Loginov"
Date:
Hi, all!

 I develop a PostgreSQL DataBase Manager. You can download it from
 http://www.tsk.ru/~ldu/kpsqlman-0.2.tar.gz
or
 ftp://ftp.kde.org/pub/kde/Incoming/unsorted/kpsqlman-0.2.tar.gz

It is beta so don't expect much so far.
You need KDE&QT to run it. Go http:\\www.kde.org to know more.
Now I work hard on the next release.

 BUT I've got some questions:
 1. In what table tables's fields and their types are stored?
 2. How do I distinguish views from tables? [not in psql of course but using
queries].
 3. Is there any way to get pointers to all connections to Postgres
backends? I need it for tracing all connections to Postgres.

 Send queries to me and we'll have a great PGManager soon!
 Don't forget to indicate version of PG you use.

Denis Loginov.
<ldu@cons.tsk.ru>



Re: [ADMIN] PostgreSQL DataBase Manager

From
Bruce Momjian
Date:
[Charset koi8-r unsupported, filtering to ASCII...]
> Hi, all!
>
>  I develop a PostgreSQL DataBase Manager. You can download it from
>  http://www.tsk.ru/~ldu/kpsqlman-0.2.tar.gz
> or
>  ftp://ftp.kde.org/pub/kde/Incoming/unsorted/kpsqlman-0.2.tar.gz
>
> It is beta so don't expect much so far.
> You need KDE&QT to run it. Go http:\\www.kde.org to know more.
> Now I work hard on the next release.
>
>  BUT I've got some questions:
>  1. In what table tables's fields and their types are stored?
>  2. How do I distinguish views from tables? [not in psql of course but using
> queries].
>  3. Is there any way to get pointers to all connections to Postgres
> backends? I need it for tracing all connections to Postgres.

psql.c is a wealth of information.  It does everything through queries.
The current psql.c in the source tree is even better with the \d[ofTa]
commands.

I can sent it do you if can't get the current source tree.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)