pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedbackup of a specific schema
7+ messages / 3 participants
[nested] [flat]
* backup of a specific schema
@ 2004-08-27 05:51 Kenneth Gonsalves <lawgon@thenilgiris.com>
2004-08-27 07:53 ` Re: backup of a specific schema Riccardo G. Facchini <abief_ag_-postgresql@yahoo.com>
2004-08-27 07:58 ` Re: backup of a specific schema Kenneth Gonsalves <lawgon@thenilgiris.com>
0 siblings, 2 replies; 7+ messages in thread
From: Kenneth Gonsalves @ 2004-08-27 05:51 UTC (permalink / raw)
To: pgsql-sql
hi,
is there anyway to backup/restore a specfic schema in a database?
--
regards
kg
http://www.onlineindianhotels.net - fastest hotel search website in the world
http://www.ootygolfclub.org
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: backup of a specific schema
2004-08-27 05:51 backup of a specific schema Kenneth Gonsalves <lawgon@thenilgiris.com>
@ 2004-08-27 07:53 ` Riccardo G. Facchini <abief_ag_-postgresql@yahoo.com>
1 sibling, 0 replies; 7+ messages in thread
From: Riccardo G. Facchini @ 2004-08-27 07:53 UTC (permalink / raw)
To: Kenneth Gonsalves <lawgon@thenilgiris.com>; pgsql-sql
check pg_dump options, is there
--- Kenneth Gonsalves <__> wrote:
> hi,
> is there anyway to backup/restore a specfic schema in a database?
> --
> regards
> kg
>
> http://www.onlineindianhotels.net - fastest hotel search website in
> the world
> http://www.ootygolfclub.org
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: backup of a specific schema
2004-08-27 05:51 backup of a specific schema Kenneth Gonsalves <lawgon@thenilgiris.com>
@ 2004-08-27 07:58 ` Kenneth Gonsalves <lawgon@thenilgiris.com>
2004-08-28 02:16 ` Re: backup of a specific schema Gaetano Mendola <mendola@bigfoot.com>
1 sibling, 1 reply; 7+ messages in thread
From: Kenneth Gonsalves @ 2004-08-27 07:58 UTC (permalink / raw)
To: Michalis Kabrianis <mk@interzone.gr>; pgsql-sql
On Friday 27 August 2004 01:17 pm, Michalis Kabrianis wrote:
> Kenneth Gonsalves wrote:
> > hi,
> > is there anyway to backup/restore a specfic schema in a database?
>
> Hi,
> isn't this what pg_dump --schema=SCHEMA does?
thanx - was looking in the wrong place in the manual
--
regards
kg
http://www.onlineindianhotels.net - fastest hotel search website in the world
http://www.ootygolfclub.org
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: backup of a specific schema
2004-08-27 05:51 backup of a specific schema Kenneth Gonsalves <lawgon@thenilgiris.com>
2004-08-27 07:58 ` Re: backup of a specific schema Kenneth Gonsalves <lawgon@thenilgiris.com>
@ 2004-08-28 02:16 ` Gaetano Mendola <mendola@bigfoot.com>
2004-08-28 12:48 ` Re: backup of a specific schema Gaetano Mendola <mendola@bigfoot.com>
0 siblings, 1 reply; 7+ messages in thread
From: Gaetano Mendola @ 2004-08-28 02:16 UTC (permalink / raw)
To: Kenneth Gonsalves <lawgon@thenilgiris.com>
Kenneth Gonsalves wrote:
> On Friday 27 August 2004 01:17 pm, Michalis Kabrianis wrote:
>
>>Kenneth Gonsalves wrote:
>>
>>>hi,
>>>is there anyway to backup/restore a specfic schema in a database?
>>
>>Hi,
>>isn't this what pg_dump --schema=SCHEMA does?
>
>
> thanx - was looking in the wrong place in the manual
Which one ?
Regards
Gaetano Mendola
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: backup of a specific schema
2004-08-27 05:51 backup of a specific schema Kenneth Gonsalves <lawgon@thenilgiris.com>
2004-08-27 07:58 ` Re: backup of a specific schema Kenneth Gonsalves <lawgon@thenilgiris.com>
2004-08-28 02:16 ` Re: backup of a specific schema Gaetano Mendola <mendola@bigfoot.com>
@ 2004-08-28 12:48 ` Gaetano Mendola <mendola@bigfoot.com>
2004-08-28 23:59 ` Re: backup of a specific schema Kenneth Gonsalves <lawgon@thenilgiris.com>
0 siblings, 1 reply; 7+ messages in thread
From: Gaetano Mendola @ 2004-08-28 12:48 UTC (permalink / raw)
To: Kenneth Gonsalves <lawgon@thenilgiris.com>; pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Kenneth Gonsalves wrote:
| On Saturday 28 August 2004 07:46 am, Gaetano Mendola wrote:
|
|>Kenneth Gonsalves wrote:
|>
|>>On Friday 27 August 2004 01:17 pm, Michalis Kabrianis wrote:
|>>
|>>>Kenneth Gonsalves wrote:
|>>>
|>>>>hi,
|>>>>is there anyway to backup/restore a specfic schema in a database?
|>>>
|>>>Hi,
|>>>isn't this what pg_dump --schema=SCHEMA does?
|>>
|>>thanx - was looking in the wrong place in the manual
|>
|>Which one ?
|
|
| backup/restore
Well, that chapter speak about pg_dump, don't you had the curiosity
to look at the complete options for that command ? :-)
Regards
Gaetano Mendola
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBMH8m7UpzwH2SGd4RAquSAKCDzx1l0dwnar1ZLIjSeHnr2TKyZgCgzKW9
2Jk/+LoMiTv0yRXEqbu3A3o=
=jUGa
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: backup of a specific schema
2004-08-27 05:51 backup of a specific schema Kenneth Gonsalves <lawgon@thenilgiris.com>
2004-08-27 07:58 ` Re: backup of a specific schema Kenneth Gonsalves <lawgon@thenilgiris.com>
2004-08-28 02:16 ` Re: backup of a specific schema Gaetano Mendola <mendola@bigfoot.com>
2004-08-28 12:48 ` Re: backup of a specific schema Gaetano Mendola <mendola@bigfoot.com>
@ 2004-08-28 23:59 ` Kenneth Gonsalves <lawgon@thenilgiris.com>
2004-08-29 11:20 ` Re: backup of a specific schema Gaetano Mendola <mendola@bigfoot.com>
0 siblings, 1 reply; 7+ messages in thread
From: Kenneth Gonsalves @ 2004-08-28 23:59 UTC (permalink / raw)
To: Gaetano Mendola <mendola@bigfoot.com>; pgsql-sql
On Saturday 28 August 2004 06:18 pm, Gaetano Mendola wrote:
> |
> | backup/restore
>
> Well, that chapter speak about pg_dump, don't you had the curiosity
> to look at the complete options for that command ? :-)
yes. so i looked in the book from which i was learning postgres. it gave
about 3 options and didnt say there were more. so i didnt look further. i
thought maybe it has to be done programmatically which is why i posted the
query
--
regards
kg
http://www.onlineindianhotels.net - fastest hotel search website in the world
http://www.ootygolfclub.org
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: backup of a specific schema
2004-08-27 05:51 backup of a specific schema Kenneth Gonsalves <lawgon@thenilgiris.com>
2004-08-27 07:58 ` Re: backup of a specific schema Kenneth Gonsalves <lawgon@thenilgiris.com>
2004-08-28 02:16 ` Re: backup of a specific schema Gaetano Mendola <mendola@bigfoot.com>
2004-08-28 12:48 ` Re: backup of a specific schema Gaetano Mendola <mendola@bigfoot.com>
2004-08-28 23:59 ` Re: backup of a specific schema Kenneth Gonsalves <lawgon@thenilgiris.com>
@ 2004-08-29 11:20 ` Gaetano Mendola <mendola@bigfoot.com>
0 siblings, 0 replies; 7+ messages in thread
From: Gaetano Mendola @ 2004-08-29 11:20 UTC (permalink / raw)
To: Kenneth Gonsalves <lawgon@thenilgiris.com>; +Cc: pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Kenneth Gonsalves wrote:
| On Saturday 28 August 2004 06:18 pm, Gaetano Mendola wrote:
|
|
|>|
|>| backup/restore
|>
|>Well, that chapter speak about pg_dump, don't you had the curiosity
|>to look at the complete options for that command ? :-)
|
|
| yes. so i looked in the book from which i was learning postgres. it gave
| about 3 options and didnt say there were more. so i didnt look further. i
| thought maybe it has to be done programmatically which is why i posted the
| query
Is better alway take a look at the on-line doocumentation, in this way you'll
be sure to be up-to-date.
Regards
Gaeatano Mendola
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBMbvg7UpzwH2SGd4RApdvAKD1MFtYwnsShQIiEvfuQ5y6fZI71wCgpweH
WiqNRGoDaNy11W18Dg40/EE=
=3a5m
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2004-08-29 11:20 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-27 05:51 backup of a specific schema Kenneth Gonsalves <lawgon@thenilgiris.com>
2004-08-27 07:53 ` Riccardo G. Facchini <abief_ag_-postgresql@yahoo.com>
2004-08-27 07:58 ` Kenneth Gonsalves <lawgon@thenilgiris.com>
2004-08-28 02:16 ` Gaetano Mendola <mendola@bigfoot.com>
2004-08-28 12:48 ` Gaetano Mendola <mendola@bigfoot.com>
2004-08-28 23:59 ` Kenneth Gonsalves <lawgon@thenilgiris.com>
2004-08-29 11:20 ` Gaetano Mendola <mendola@bigfoot.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