X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 752E4534E4
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  6 May 2005 14:56:51 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 51779-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  6 May 2005 17:56:44 +0000 (GMT)
Received: from zhonka1.zhonka.net (zhonka1.zhonka.net [66.228.195.5])
	by svr1.postgresql.org (Postfix) with ESMTP id A15055334F
	for <pgsql-sql@postgresql.org>; Fri,  6 May 2005 14:56:43 -0300 (ADT)
Received: from wolf.pjkh.com ([66.228.196.74]) by zhonka1.zhonka.net
	(Post.Office MTA v3.5.3 release 223 ID# 0-58414U4500L450S0V35)
	with ESMTP id net; Fri, 6 May 2005 10:56:42 -0700
Received: from localhost (localhost [127.0.0.1])
	by wolf.pjkh.com (Postfix) with ESMTP id C22575891;
	Fri,  6 May 2005 10:56:24 -0700 (PDT)
Received: from wolf.pjkh.com ([127.0.0.1])
	by localhost (wolf.pjkh.com [127.0.0.1]) (amavisd-new,
	port 10024) with ESMTP
	id 39963-02; Fri,  6 May 2005 10:56:24 -0700 (PDT)
Received: by wolf.pjkh.com (Postfix, from userid 1000)
	id 8E9F55890; Fri,  6 May 2005 10:56:24 -0700 (PDT)
Received: from localhost (localhost [127.0.0.1])
	by wolf.pjkh.com (Postfix) with ESMTP id 8880557BA;
	Fri,  6 May 2005 10:56:24 -0700 (PDT)
Date: Fri, 6 May 2005 10:56:24 -0700 (PDT)
From: Philip Hallstrom <postgresql@philip.pjkh.com>
To: Kenneth Gonsalves <lawgon@thenilgiris.com>
Cc: PostgreSQL SQL <pgsql-sql@postgresql.org>
Subject: Re: pg_dump without data
In-Reply-To: <200505061444.29591.lawgon@thenilgiris.com>
Message-ID: <20050506105546.U40081@wolf.pjkh.com>
References: <200505061444.29591.lawgon@thenilgiris.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-Virus-Scanned: by amavisd-new at pjkh.com
X-Virus-Scanned: by amavisd-new at hub.org
X-Archive-Number: 200505/54
X-Sequence-Number: 21367

> how do i get a dump of a postgresql database without the data?

% pg_dump --help
pg_dump dumps a database as a text file or to other formats.

Usage:
   pg_dump [OPTION]... [DBNAME]

.....

   -s, --schema-only        dump only the schema, no data

....

-philip