Re: describe table query?

I also would love to know how you do this, because I am REALLY missing the "DESCRIBE <table>" calls...

I work with mostly PHP4...

please help!

regards,
dan

On Tue, 10 Sep 2002 03:07:46 +0200
snpe <snpe(at)snpe(dot)co(dot)yu> wrote:

> If You use java then that is DatabaseMetaData.getColumns etc
>
> regards
> Haris Peco
> On Monday 09 September 2002 11:30 pm, Andrew Bulmer wrote:
> > I'm trying to write an Access clone in java that will
> > use PostGres as a backend. Problem is, I need to be
> > able to list all the fields (and data types) in a
> > table. I know about "\d" but that only seems to work
> > on the command line client (doesn't work if I pass it
> > in as a query). I know in mysql DESCRIBE <table> will
> > do it... is there an equivalent in postgres? I tried
> > google but all I could find were references to the \d command.
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Finance - Get real-time stock quotes
> > http://finance.yahoo.com
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html