Skip site navigation (1) Skip section navigation (2)

Dumping tables with only create statements

From: "Ridvan Lakas ng Bayan S(dot) Baluyos" <ridvan(at)baluyos(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Dumping tables with only create statements
Date: 2008-06-27 07:46:01
Message-ID: 7f4f9efa0806270046i4a10982ds149f038cdd3f0528@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Is there a way wherein I can dump only the create statements (plus the
indexes and triggers) of a `specific` table without including the data? I
just need the dump of the table structure, indexes, and triggers.


Thanks in advance,


Ridvan

-- 
リヅバン バルヨス
ridvan(dot)baluyos(at)qualservcentral(dot)com
http://ridvan.baluyos.net
http://www.onxiam.com/people/rbaluyos

Registered Linux User #439466
Registered Ubuntu User #16034
Q: Have you heard of the Object-Oriented way to get wealthy?
A: Inheritance.

Responses

pgsql-novice by date

Next:From: Ridvan Lakas ng Bayan S. BaluyosDate: 2008-06-27 08:26:19
Subject: Re: Dumping tables with only create statements
Previous:From: P KapatDate: 2008-06-26 21:22:02
Subject: Re: how to replicate a database from one machine to the other?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group