Thread: Table Listing Info

This seems like it would be a pretty simple thing to
do: I just want to use a client like libpq (hopefully
PHP too) to list the table info in the current DB.
The info I want is the same you would get with a '\d
*' in psql.

Also, I was going to make an HTML/CGI based PG client.
Is there already a project in existence like this, or
should I go ahead and make a nice one (that other
people could use too)?

Thanks,
Jeff Davis
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com

Jeff Davis wrote:
>
> Also, I was going to make an HTML/CGI based PG client.
> Is there already a project in existence like this, or
> should I go ahead and make a nice one (that other
> people could use too)?

There are a few things along this line in CPAN in combination with
DBI, but I haven't used them.  I'd be pleased to hear what you find
works...

There is also pgaccess, which does pretty much what you describe,
IIRC.

Cheers,
Ed Loehr

hi, guys,

I  almost finish porting a schedular from linux/pg/apache
to nt/m$sql/iis (there is going to be a headach of iis security --
any ideas? ).

I understand that some people may feel uneasy about this, however, note
that we are engineers, not the boss, nor the customers. So, even
in closed-software :-) situation it's other end's problem(in this
case, M$shit's "issue"), but aren't oss totally different from THEM!
also, it is good for marketing to get people into PG by saying that
after all, if you are not satisfied, to get out of PG is easy!

I'll give a report of this experience. -- I can not develop the db
itself now (ya, someday, I will try the oodb or data warehouse/datamining
feature, someday :-), at lease I can do this.

However, now I just want to say: I now apprecaite PG much much more than
before. PG is great! perhaps only second to Oracle (perhaps after
I port it to oracle, I will find PG is the best!). But surely, it
is better than M$sql. you see what, M$sql can not support two sequences
in one table, it's varchar field can not be longer than 255 chars, and,
its text type does not work right if you use common sql, what's more,
also, the programming interface of "select currval(...)"
(select @@identty) does not work. (I have to lock the table's insert
and max(productId) ). ...

thanks for your great work.