Getting table attributes

From: "C G" <csgcsg39(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Getting table attributes
Date: 2004-02-06 16:53:47
Message-ID: LAW12-F1191wil1zjnj0004d472@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear All,

I'm trying to get a table containing all the user created tables, which
contains the column name and their types. Basically, I want to be able to
do "\d all_user_tables" - but I can't use the \d notation.

I tried to combine the pg_ tables, but I couldn't get what I wanted (due to
my lack of skill).

Any ideas?

Thanks

Colin

_________________________________________________________________
Find a cheaper internet access deal - choose one to suit you.
http://www.msn.co.uk/internetaccess

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christoffer Gurell 2004-02-06 17:04:22 retrieving parts of a resultset
Previous Message Pavel Stehule 2004-02-06 16:24:46 Re: how can I select into an array?