Restoring to a certain schema

From: "Opis Boi" <anci(at)centrin(dot)net(dot)id>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Restoring to a certain schema
Date: 2003-02-20 04:59:20
Message-ID: 003101c2d89c$d4765da0$0200a8c0@edpmgr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear All

I have a dump file from v7.2.3 and wanted to restore it to a certain schema in v7.3.2 ( let's call it the abc schema ).
The abc schema is also not the same with my username.
So, if I take a look at the search_path, the $user,public won't take me there.
How do I do that ?
I've take look on the pg_restore options but it seems none of the option provides the solution.
Any idea ? ( except to restore it to the public and copy the tables to the abc schema ? )

Thank you in advance
Andy

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar<shridhar_daithankar@persistent.co.in> 2003-02-20 06:32:01 Re: 7.3.1 takes long time to vacuum table?
Previous Message Martijn van Oosterhout 2003-02-20 04:21:40 Re: 7.3.1 takes long time to vacuum table?