Re: Schema version management

Joel Jacobson <joel@trustly.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