Re: plpgsql functions organisation

On 05/02/2015 09:53 AM, Yves Dorfsman wrote:
>
> I find my plpgsql functions becomes unreadable very quickly. I want to break
> them up in smaller functions.
>
> What is the best way to organised them?
> Is there any way to define functions inside functions?
> When I list functions in psql, I can see them all at the same level, is there
> any way to organise them in packages like with python and other languages, so
> the smaller functions are hidden away in a package/directory?

The  only thing I can think of is to use SCHEMAs;

http://www.postgresql.org/docs/9.4/interactive/sql-createschema.html

>
>
> Thanks.
>


--
Adrian Klaver
adrian.klaver@aklaver.com