Обсуждение: how to print a schema

Поиск
Список
Период
Сортировка

how to print a schema

От
mrodriguez@curreyadkins.com
Дата:
Does anybody know how to print a schema in PostgreSQL? I know you can
look at one table at at time, but is there a way to print all columns
and rows at once?

thanks.


Re: how to print a schema

От
"Rodrigo De León"
Дата:
On 8/27/07, mrodriguez@curreyadkins.com <mrodriguez@curreyadkins.com> wrote:
> Does anybody know how to print a schema in PostgreSQL? I know you can
> look at one table at at time, but is there a way to print all columns
> and rows at once?

1. pg_dump / pg_dumpall
   http://www.postgresql.org/docs/8.2/static/backup-dump.html

2. PostgreSQL Autodoc
   http://www.rbt.ca/autodoc/