Home > mailing lists

Restoring to a certain schema - Mailing list pgsql-general

From	Opis Boi
Subject	Restoring to a certain schema
Date	February 20, 2003 03:23:45
Msg-id	003101c2d89c$d4765da0$0200a8c0@edpmgr Whole thread Raw
Responses	Re: Restoring to a certain schema
List	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

From: Justin Clift
Date: 20 February 2003, 02:47:59
Subject: Re: How do I upgrade or coexist PostgreSQL on a Cobalt

From: "Shridhar Daithankar"
Date: 20 February 2003, 04:31:45
Subject: Re: 7.3.1 takes long time to vacuum table?