Thread: backup of a specific schema
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
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 >
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
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
-----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-----
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
-----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-----