Howdy:
Please redirect me if this is the wrong group. My question
is pretty much SQL related for Postres.
I want to write a script (either shell or SQL) to:
1) get a list of tables
2) get the list of attributes, type and modifyer
of each table.
It is something in the way of:
for i in `\d`
do
\d $i
done
As far as I can tell, '\d' describes a table, view or what
have you. '\d' alone gives me a list of tables and views I
have in my database.
Any examples out there that does this?
TIA!
-X