Changing fileds of all database tables

From: Aleksandar Dezelin <dezelin32(at)fastmail(dot)fm>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Changing fileds of all database tables
Date: 2004-11-04 15:47:31
Message-ID: 418A4F13.8060902@fastmail.fm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have a small problem:
I want to convert an existing MSSQL database to PostgreSQL but as
PostgreSQL doesn't support uniqueidentifier I want first to convert all
database tables fields of type Guid to nchar in MSSQL database and after
that to import it into PostgreSQL. Does anybody knows how to convert all
database tables fields from one type to another in MSSQL?

Thanks in advance,
Aleksandar Dezelin

--
Linux is like wigwam - no windows, no gates and apache inside. ...

Browse pgsql-novice by date

  From Date Subject
Next Message Nigel Metheringham 2004-11-04 17:34:03 How to handle a group query
Previous Message Crombleholme, Roy 2004-11-04 15:36:24 FW: pg_ [dump & restore] invalid archive problem