Thread: Dumping tables with only create statements
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.baluyos@qualservcentral.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.
Thanks in advance,
Ridvan
--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.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.
I already found the solution.
pg_dump -h <host> -U <user> <dbname> -t <table> -s > <file>
I thought that having the `-s` parameter would only mean dumping the schema of the entire database. I just learned that you can use it when you want to dump the schema of a specific table only.
Thanks,
Ridvan
--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.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.
pg_dump -h <host> -U <user> <dbname> -t <table> -s > <file>
I thought that having the `-s` parameter would only mean dumping the schema of the entire database. I just learned that you can use it when you want to dump the schema of a specific table only.
Thanks,
Ridvan
On Fri, Jun 27, 2008 at 3:46 PM, Ridvan Lakas ng Bayan S. Baluyos <ridvan@baluyos.net> wrote:
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.baluyos@qualservcentral.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.
--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.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.