RE: How to add function schema in search_path in option definitio

Hi, We have hit similar issues with the software that we develop. We don’t specify the schema names in stored procedures/functions we create. The way we resolved it was to define the schemas where the stored procedures/functions are located in the search path as part of the connection string w

Questions on PostgreSQL 13.4 Installer for Windows

Hi, Our developers do their work using a local PostgreSQL database server and local schemas. This is typically done by installing the Windows version of the PostgreSQL installer from EnterpriseDB. Currently, version 13.4 (64-bit) of the installer is being used. Recently, our organization has

RE: Migrating PostgreSQL Stored Procedures to MSSQL 2019 for example

Hi, When we did our migration from SQL Server to PostgreSQL, we mainly used two tools: sqlserver2pgsql for most of our schema-related changes. You can find that here: https://github.com/dalibo/sqlserver2pgsql. AWS Schema Conversion Tool (SCT) for migrating views and stored functions/procedures

Tools to convert timestamp data to another time zone in PostgreSQL

Hi, We have recently modified our application to work with PostgreSQL databases and schemas. We also support Oracle and SQL Server Databases. Along with adding support for PostgreSQL, we have upgraded our infrastructure such that all environments are configured to use the UTC time zone. Previou

Performance question about using autosave=always and cleanupSavepoints=true

Hi, Currently, our application supports SQL Server databases and Oracle schemas. We are updating our application to support PostgreSQL schemas. We are using version 13.4 of PostgreSQL. Our application is written in Java and connects to PostgreSQL schemas using JDBC. In our framework, we have