Обсуждение: 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.

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.