Re: how to print a schema

From: Rodrigo De León <rdeleonp(at)gmail(dot)com>
To: "mrodriguez(at)curreyadkins(dot)com" <mrodriguez(at)curreyadkins(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how to print a schema
Date: 2007-08-30 04:16:18
Message-ID: a55915760708292116o7004c95aw7bea8599c7425a68@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/27/07, mrodriguez(at)curreyadkins(dot)com <mrodriguez(at)curreyadkins(dot)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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Manchenahalli, Raghunandan (STSD) 2007-08-30 04:53:24 Timezone - UTC
Previous Message Nitin Verma 2007-08-30 04:13:33 What kind of locks does vacuum process hold on the db?