the odbc drv suports shemas.. only pass parameter to odbc
> ConnSettings = SET search_path TO myshema, public in odbc.ini or ~/.odbc.ini file if u may need set differents servers to differents shemas must made direrents connections inside archive and each connections have specific ConnSettings parameters, by example theres th odbc file for tow difrfernet servers connectins: NOTE: must take care of Oid show due sql script of jabberd dont make index columns and fail to edit data, also u must hide system table in production environment firts conection have shema virtualservera of database ejabberdvnx and second named PSQLvirtualserverb have shema access virtualserverb into same database sysmail00:/home/massenkoh/devel/venenux# cat /etc/odbc.ini [PSQLvirtualservera] Description = PostgreSQL venenux.org conection Driver = PostgreSQL Unicode Trace = No TraceFile = /var/log/psqlodbc.log Database = ejabberdvnx Servername = localhost UserName = sistem Password = clave_de_sistem Port = 5432 ReadOnly = No RowVersioning = No ShowSystemTables = Yes ShowOidColumn = Yes FakeOidIndex = No ConnSettings = SET search_path TO virtualservera [PSQLvirtualserverb] Description = PostgreSQL venenux.org conection Driver = PostgreSQL Unicode Trace = No TraceFile = /var/log/psqlodbc.log Database = ejabberdvnx Servername = localhost UserName = sistem Password = clave_de_sistem Port = 5432 ReadOnly = No RowVersioning = No ShowSystemTables = Yes ShowOidColumn = Yes FakeOidIndex = No ConnSettings = SET search_path TO virtualserverb sysmail00:/home/massenkoh/devel/venenux# -- Lenz McKAY Gerardo (PICCORO) http://qglochekone.blogspot.com
