Creating Functions in Separate Schema
От | Mark Dexter |
---|---|
Тема | Creating Functions in Separate Schema |
Дата | |
Msg-id | 5E8F9F5B63726C48836757FE673B584EF74CB5@dcimail.dexterchaney.local обсуждение исходный текст |
Ответы |
Re: Creating Functions in Separate Schema
Re: Creating Functions in Separate Schema Re: Creating Functions in Separate Schema |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: