Re: [SQL] backup of a specific schema

2004-08-29 Thread Gaetano Mendola
-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

Re: [SQL] backup of a specific schema

2004-08-28 Thread Kenneth Gonsalves
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 opt

Re: [SQL] backup of a specific schema

2004-08-28 Thread 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

Re: [SQL] backup of a specific schema

2004-08-27 Thread Gaetano Mendola
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 ? Re

Re: [SQL] backup of a specific schema

2004-08-27 Thread Kenneth Gonsalves
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:/

Re: [SQL] backup of a specific schema

2004-08-27 Thread Riccardo G. Facchini
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 > > ---

[SQL] backup of a specific schema

2004-08-27 Thread Kenneth Gonsalves
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 fr