Re: [ADMIN] PostgreSQL DataBase Manager

[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(at)candle(dot)pha(dot)pa(dot)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)