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
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
>
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
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
iD8DBQFBMH8m7UpzwH2SGd4RAquSAKCDzx1l0dwnar1ZLIjSeHnr2TKyZgCg zKW9
2Jk/+LoMiTv0yRXEqbu3A3o=
=jUGa
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
-----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
iD8DBQFBMbvg7UpzwH2SGd4RApdvAKD1MFtYwnsShQIiEvfuQ5y6fZI71wCg pweH
WiqNRGoDaNy11W18Dg40/EE=
=3a5m
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match