Our application currently runs in Microsoft SQL Server and we are
porting it over to Postgres.  When we write enbedded SQL queries for SQL
Server, we need to reference user-defined functions with the prefix
"dbo." (e.g., "dbo.Function_Name()").  In experimenting with Postgres,
it appears that we can create a schema called "dbo" and then reference
functions with the same syntax (e.g., "dbo.Function_Name()").  

We're trying to understand whether there will be any disadvantages to
doing this.  Are there any possible issues or problems with this
approach?  Any help will be greatly appreciated.  Thanks.  

Responses

• Re: Creating Functions in Separate Schema at 2004-08-27 05:37:08 from Tino Wildenhain
• Re: Creating Functions in Separate Schema at 2004-08-27 07:57:24 from Richard Huxton
• Re: Creating Functions in Separate Schema at 2004-08-27 09:08:10 from Oliver Elphick

pgsql-general by date

Next:	From: Benjamin Smith	Date: 2004-08-26 22:04:29
	Subject: Re: Constraints to Guarantee unique across tables with foreign key?
Previous:	From: Gaetano Mendola	Date: 2004-08-26 21:33:46
	Subject: Re: Possible to insert quoted null value into integer field?