Joel Jacobson <joel(at)trustly(dot)com> writes:
> On Thursday, July 12, 2012, Tom Lane wrote:
>> What are you going to do with objects that don't have schemas?
>> (Including, but not restricted to, the schemas themselves.)
> Good question. Maybe something like this?
> For objects without schema:
> /global/[type]/[name].sql
> For objects with schema:
> /schema/[schema]/[type]/[name].sql
FWIW, I think you could save a level of naming if you were willing to
put the type first, since the type would imply whether the object
lives in a schema or not:
[type]/[name].sql
[type]/[schema]/[name].sql
regards, tom lane