Re: Naive schema questions

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
Cc: Postgresql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Naive schema questions
Date: 2004-05-27 12:10:35
Message-ID: 200405271410.35056.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Donnerstag, 27. Mai 2004 13:15 schrieb Rory Campbell-Lange:
> I imagined schemas might allow me to globally update functions across a
> database hosting many schemas with the same structure.

Put your data tables in separate schemas, put the functions in yet another
schema, and then when you connect set the schema search path to "dataschema,
functionschema" (or maybe vice versa).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2004-05-27 12:18:14 Re: Naive schema questions
Previous Message Rory Campbell-Lange 2004-05-27 11:15:59 Naive schema questions