Re: Name spacing functions and stored procedures - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Name spacing functions and stored procedures
Date
Msg-id CAFj8pRA6_1OT5qiPFfGGcYe67yfZ1E6sO_wXZZHZbqiy8eFfsg@mail.gmail.com
Whole thread Raw
In response to Name spacing functions and stored procedures  (Tim Uckun <timuckun@gmail.com>)
Responses Re: Name spacing functions and stored procedures  (Tim Uckun <timuckun@gmail.com>)
Re: Name spacing functions and stored procedures  (Steven Erickson <Steven.Erickson@telventdtn.com>)
List pgsql-general
Hi

2015-03-19 2:56 GMT+01:00 Tim Uckun <timuckun@gmail.com>:
What do you guys do to namespace your functions so that they are not jumbled in with the system functions and also somewhat hierarchically organized.

Obviously it's possible to create schemas for different namespaces but that can lead to a lot of schemas which hold no data.   The other way is to simply name your functions like _lib_etl_csv_import_weird_data_format but that's not too much fun either.

What is problem with schemas? It is tool for logical database structuring - for tables, for functions.

I use schemas without any problems.
 

Just curious how other people deal with the issue.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Archeiving and Purging
Next
From: Haribabu Kommi
Date:
Subject: Unicode license compatibility with PostgreSQL license