Обсуждение: Migration from MS Server to Postgres

Hi

I am trying to migrate MS SQL 6.5 database server to the postgresql database
)7.1). I have my program made in Power Builder and this program is working
without problems with MS SQL server. But when I tried to change the database
to the PostgreSQL I received following errors:
1. The program(Power Builder) is not recognizing more big and small letters
(case sensitivity).
2. There is also problem with spaces ,with that is also having PosgreSQL
problems.

How can I fix that problem with letters? Is there any special way how to
build PostgreSQL ,so it is working well with PowerBuilder and especially
with small and big letters.

The PostgreSQL is running on Linux and PowerBuilder on Windows.

Thanks for all your answers



_________________________________________________________________
MSN Fotos: la forma más fácil de compartir e imprimir fotos.
http://photos.msn.es/support/worldwide.aspx

> -----Original Message-----
> From: Eduardo Palafox [mailto:mike_wazowski2002@hotmail.com]
> Sent: 26 June 2002 00:31
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Migration from MS Server to Postgres
>
>
>
> Hi
>
> I am trying to migrate MS SQL 6.5 database server to the
> postgresql database
> )7.1). I have my program made in Power Builder and this
> program is working
> without problems with MS SQL server. But when I tried to
> change the database
> to the PostgreSQL I received following errors:
> 1. The program(Power Builder) is not recognizing more big and
> small letters
> (case sensitivity).
> 2. There is also problem with spaces ,with that is also
> having PosgreSQL
> problems.
>
> How can I fix that problem with letters? Is there any special
> way how to
> build PostgreSQL ,so it is working well with PowerBuilder and
> especially
> with small and big letters.
>
> The PostgreSQL is running on Linux and PowerBuilder on Windows.

Hi

This isn't really the best list for this but make sure that your object
names in your sql queries are quoted if they contain mixed case letters,
or any non-alpha characters other than underscore e.g.

SELECT * FROM "Table Name"

Better yet, make all the table names lower case with no characters other
than _

Regards, Dave