pg_dump from 7.3 to 7.2

From: Ryszard Lach <rla(at)id(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump from 7.3 to 7.2
Date: 2003-03-17 17:30:24
Message-ID: 20030317173024.GD15125@siaco.id.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

A database dump (plain text version) generated on postgresql 7.3
contains explicit schema names (public.) in drop and create statements,
which makes it difficult to load such a dump into 7.2 (one can edit the
file and remove all 'public.' strings, but that's not an ideal
solution).

Is there a good method for performing such a migration?

Richard.

--
** Internet Designers S.A., ul. Przedmiejska 6-10, 54-201 Wrocław **
tel. (071) 35 00 445 w. 25; fax (071) 37 35 946; http://www.id.pl/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Wilson 2003-03-17 18:43:20 Re: query optimisation
Previous Message Stephan Szabo 2003-03-17 17:00:42 Re: Change column type