> -----Original Message----- > From: Eduardo Palafox [mailto:[EMAIL PROTECTED]] > Sent: 26 June 2002 00:31 > To: [EMAIL PROTECTED] > 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
