Marcin Inkielman <[EMAIL PROTECTED]> writes:
> I am migrating a relativly huge database from postgres 7.2 to 8.0. I
> need to alter schema
> for sth about 500 tables and twice as many other objects. Do I need to
> sth other on a new database than:
I'd suggest updating to 8.1 (where there's ALTER S
Hi!
I am migrating a relativly huge database from postgres 7.2 to 8.0. I
need to alter schema
for sth about 500 tables and twice as many other objects. Do I need to
sth other on a new database than:
create schema ... ;
update pg_class set relnamespace =$oid_of_new_schema where
relnamespace=$oid_o
