Re: Migration from SQLServer

On Fri, 16 May 2003, Nigel J. Andrews wrote:

> On Fri, 16 May 2003, Tapan Trivedi wrote:
>
> > b. Create script. Let me explain - I generated the script from MSSQL and
> > it gave a whole lot of issues (for SQL statements and types) . When  I
> > resolved all of them, I encountered Relation ".." not found error. The
> > only way I could resolve it was by giving the table names in quotes. I
> > guess I should have converted all table names in lowercase and then all
> > would be OK.
> >
> > What I am trying to find out now is - Is there anyway I can avoid
> > dropping the database and recreating it ??
>
> Sure, take a look at relname in pg_class and typname in pg_type.  The other
> columns in those table will help you decide who owns what and what schema
> they're in so you can change only those ones you want to.

Oh, and don't forget to start a transaction before making the changes so that
you get the chance to rollback if you make a mistake, these are system tables.


--
Nigel Andrews