Search Postgresql Archives

Re: fine tuned database dump/reload?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux