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