PostgreSQL tables in a schema

Guy Fraser guy at incentre.net
Fri Apr 21 17:31:38 CEST 2006


On Thu, 2006-20-04 at 20:02 +0300, Milen A. Radev wrote:
> Is it possible to place the necessary tables in a separate schema? We
> need to cross-reference some tables and it would be very convenient if
> we could place the tables inside the same database together with our
> other schemas. I saw that same table names are specified in the
> configuration file (postgresql.conf). Probably it would be easy to
> prepend the schema name. But I saw some other tables in the DB that
> are not mentioned in the conf file.
> 
If that is what you want to do, go ahead. You do not need to prepend 
the the schema if the radius users path includes the schema.
Read the PostgreSQL docs, and customize the queries how ever you 
want. The config files are part of the documentation system and are 
meant to serve as samples only, it is up to you to "tweek" them.





More information about the Freeradius-Users mailing list