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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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