Your query of information_schema.tables will work fine to determine if 
slony schema is installed. You can take the results of this query 
(particularly table_schema) then call:

SELECT _table_schema.getlocalnodeid('_table_schema')

With this result, you can determine if the node is a receiver or 
provider for any sets via a query of sl_subscribe.

Regards,

JP

Knight, Doug wrote:
>
> All,
>
> I have a need to create a script that automatically determines if 
> slony is installed and replicating on a specific database. The idea is 
> that another script that handles time partitioned table drops/creates 
> could call this script to determine if it needs to do any special 
> slony processing instead of its direct drop/create statements (i.e. 
> pass the SQL via slonik EXECUTE SCRIPT). I figure I’ll be looking in 
> the information_schema schema for the current database. Is there any 
> particular place I should look (maybe the existence of an sl_status 
> table in information_schema.tables)? Any best practices would be great.
>
> Thanks,
>
> Doug Knight
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>   


-- 
JP Fletcher
Database Administrator
Afilias Canada
voice: 416.646.3304 ext. 4123
fax: 416.646.3305
mobile: 416.561.4763
jpfletch at ca.afilias.info