Dan Armbrust wrote: > Does postgresql have any facility to dump anything more fine grained > than a database to a text file? > > For example, to mention a bad word, MySQL's dump command allows you to > specify individual tables to dump <snip> > PostgreSQL's pg_dump command seems rather limited in its abilities. > Maybe I'm missing the command I'm looking for. > > Thanks, > > Dan > pg_dump --help ... -n, --schema=SCHEMA dump the named schema only -s, --schema-only dump only the schema, no data -t, --table=TABLE dump the named table only ... -- _______________________________ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. _______________________________ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend