Fw: Getting tables, procedures, etc.

yes I know!! bou my problem is much worse :)

do you know ASTA?? www.astatech.com

they have done around 15 server applications for several dbms...
but, they have not one for PostgreSQL :(

so, I'm doing one!!! and its already running nice and fast!!!
the problem is when my client app ask for any metadata... now I'm gettin it
but dont know if it is the right way?¿

for exemple:
to I get the user tables, I'm doing: select relname from
"pg_statio_user_tables"

to I get the Stored Procedures, I'm doing: select proname from "pg_proc"
(I think it is not right)

do you know other way do I get it?

> > Hey, Tora isn't just for Oracle?
> > Anyway, tora is an SQL Client, excelent by the way! Do you know Toad
> > for Windows? Is much like it.
> >
> > On Thu, 2002-10-10 at 11:57, Roberto (SmartBit) wrote:
> > > >
> > > > > How could I do to get de User Tables, System Tables, Stored
> Procedures,
> > > > > Trigger, Views, etc???
> > > > > I'd like to do the same as pgAdmin ... using a TreeView at left
and
> at
> > > rigth
> > > > > I'll show the items...
> > > >
> > > > It's all there in pg meta data. Tora is one way I have discovered
> today to
> > > get
> > > > that information easily..
> > > >
> > >
> > > Sorry my ignorance, but, what is "Tora"???
> > > How do I do to get the pg meta data using delphi??
> > >
> > > I'm trying to do something like pgAdmim ....
> > >
> > > Roberto de Amorim
> > >
> > >
> > > ---------------------------(end of
broadcast)---------------------------
> > > TIP 1: subscribe and unsubscribe commands go to
majordomo(at)postgresql(dot)org
> > --
> >
> > Felipe Schnack
> > Analista de Sistemas
> > felipes(at)ritterdosreis(dot)br
> > Cel.: (51)91287530
> > Linux Counter #281893
> >
> > Faculdade Ritter dos Reis
> > www.ritterdosreis.br
> > felipes(at)ritterdosreis(dot)br
> > Fone/Fax.: (51)32303328
> >
> >
>