By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,809 Members | 1,997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,809 IT Pros & Developers. It's quick & easy.

pg_dump table schema ...

P: n/a
Hi,

I would like to get the structures of all my tables m4_clients, m4_contacts
etc.

Help of pg_dump says :
-t, --table=TABLE dump this table only (* for all)

I have tried a :
pg_dump -U postgres -s --table=m4_* my_database
It's not give me any result ...

Neither than : (as the help says !? or I missed understand)
pg_dump -U postgres -s --table=* my_database

It's running only if I'm doing a :
pg_dump -U postgres -s --table=m4_clients my_database

Any idea for help ?

PostgreSQL v7.3.4 used !

Thanks !

Regards,
--
Hervé Piedvache

Elma Ingénierie Informatique
6 rue du Faubourg Saint-Honoré
F-75008 - Paris - France
Pho. 33-144949901
Fax. 33-144949902
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.