>>>Hello.
>>>We are in the planning stage to move our ERP from SQL Server to PostgreSql.
>>>We rely heavily in Stored Procedures and remote views and want to change as little code as possible.
>>>We have ported our databases to PostgreSQL (now we are doing the pk replacements) and would like to know any tips or experiences you have about this.
>>
>>While I haven't done a migration, I've been spending some time with PostgreSQL lately. The first big hurdle, in my view, is that it's case-sensitive for table and field names. Best practice is to make everything lowercase, since that's the default. If not, you have to live in a world of double-quotes.
>>
>>Tamar
>
>Use postix regular expressions to do case insensitive searches. select ... lastname ~* '^my name$'
>
>
https://www.postgresql.org/docs/9.3/static/functions-matching.htmlWhat I was talking about is that if your field is called Name, you can't just SELECT name or even, for that matter, SELECT Name, you have to SELECT "Name"
Tamar