On 1/23/07, Kranti <[EMAIL PROTECTED]> wrote:
Hey Guys,
This is my first email to list. Hope i will get the solution quickly.
Hi,
please use pg_dump -n option to select schema. Read manual
pages of pg_dump.I am not sure how to do it in pgadminIII
all said it is doable.
regds
malah.
I am working on postgresql 8.1
I have a DB, with mre than 4 schemas. I want to take backup of one of the
schema and restore the same schema into another DB .ofcourse schema names
are same.
I am able to take backup and restore at DB level.
but i want the same at schema level.
Using pgadmin III i am able to take backup of schema. but not able to see
restore of that schema.
I am in a very urgent need. Please do respond to this and guide me
Thanks in advance
Kranti
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
