Re: pg_dump without data

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com>
Cc: PostgreSQL SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: pg_dump without data
Date: 2005-05-06 17:59:27
Message-ID: 1115402367.3868.79.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 2005-05-06 at 04:14, Kenneth Gonsalves wrote:
> how do i get a dump of a postgresql database without the data?

pg_dump -s for the schema

pg_dumpall -g for the globals, like usernames and all.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Derek Buttineau|Compu-SOLVE 2005-05-06 19:48:32 ORDER BY Optimization
Previous Message Philip Hallstrom 2005-05-06 17:56:24 Re: pg_dump without data