>>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.html