sql script questions

Поиск
Список
Период
Сортировка
От shaunnx@my-deja.com (X)
Тема sql script questions
Дата
Msg-id 6375fd1b.0110231150.3a7b0556@posting.google.com
обсуждение исходный текст
Список pgsql-general
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Trurl McByte
Дата:
Сообщение: PgSendMail, PgLinkPoint, PgMCK (CyberCash) joins SourceForge...
Следующее
От: calberto2312@hotmail.com (Carlos Alberto)
Дата:
Сообщение: Evaluating PostgreSQL