pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dump question
3+ messages / 3 participants
[nested] [flat]
* pg_dump question
@ 2001-02-12 23:45 Carolyn Lu Wong <carolyn@greatpacific.com.au>
0 siblings, 0 replies; 3+ messages in thread
From: Carolyn Lu Wong @ 2001-02-12 23:45 UTC (permalink / raw)
To: pgsql-sql
When dumping database, is it possible to dump datetime values without
the timezone info?
I'm currentlyl using 6.5.
^ permalink raw reply [nested|flat] 3+ messages in thread
* pg_dump question
@ 2007-10-05 16:58 Judith <jaltamirano@correolux.com.mx>
2007-10-05 21:11 ` Re: pg_dump question Erik Jones <erik@myemma.com>
0 siblings, 1 reply; 3+ messages in thread
From: Judith @ 2007-10-05 16:58 UTC (permalink / raw)
To: pgsql-sql
Hello every body!! I have a quesyion respect pg_dump...........
I need to backup the db structure, I suposse that I do with pg_dump
-s, but I want to restore but just with some tables with the db
catalogues, can I do this?, I mean, restore al the db structure without
data and after restore the data of the catalogues tables??
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_dump question
2007-10-05 16:58 pg_dump question Judith <jaltamirano@correolux.com.mx>
@ 2007-10-05 21:11 ` Erik Jones <erik@myemma.com>
0 siblings, 0 replies; 3+ messages in thread
From: Erik Jones @ 2007-10-05 21:11 UTC (permalink / raw)
To: Judith <jaltamirano@correolux.com.mx>; +Cc: pgsql-sql
On Oct 5, 2007, at 11:58 AM, Judith wrote:
> Hello every body!! I have a quesyion respect pg_dump...........
>
> I need to backup the db structure, I suposse that I do with
> pg_dump -s, but I want to restore but just with some tables with
> the db catalogues, can I do this?, I mean, restore al the db
> structure without data and after restore the data of the catalogues
> tables??
Don't worry about the catalog tables. If all you want is the schema
dumped and restored then, yes, use the -s flag. The data in the
catalog tables is built as the schema is rebuilt during the restore,
i.e postgres takes care of those for you.
Erik Jones
Software Developer | Emma®
erik@myemma.com
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-10-05 21:11 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-12 23:45 pg_dump question Carolyn Lu Wong <carolyn@greatpacific.com.au>
2007-10-05 16:58 pg_dump question Judith <jaltamirano@correolux.com.mx>
2007-10-05 21:11 ` Erik Jones <erik@myemma.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox