Re: [GENERAL] ms-sql -> pg 8.x

2009-09-30 Thread Tom Lane
John R Pierce writes: > Sydney Puente wrote: >> The first isssue that occurs to me is that CP1252 is used throughout >> the data and there is a lot of european special characters, e acute >> for example. But the column names etc are regular chars [a-zA-Z]. > CP1252 aka Windows-1252 is actually

Re: [GENERAL] ms-sql -> pg 8.x

2009-09-30 Thread John R Pierce
Sydney Puente wrote: Hello, It seems that very shortly I will have to extract some data from ms-sql server and load it into postgres. It seems that the ms-sql is getting bigger with increasingly more users and performance is getting worse n worse. And a local copy of data is required for and a

[GENERAL] ms-sql -> pg 8.x

2009-09-30 Thread Sydney Puente
Hello, It seems that very shortly I will have to extract some data from ms-sql server and load it into postgres. It seems that the ms-sql is getting bigger with increasingly more users and performance is getting worse n worse. And a local copy of data is required for and application that needs p