X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 621ED535EF
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 25 Mar 2005 19:55:09 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 71590-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 25 Mar 2005 19:55:08 +0000 (GMT)
Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 0F2815356D
	for <pgsql-sql@postgresql.org>; Fri, 25 Mar 2005 19:55:08 +0000 (GMT)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
	id 23BB430959; Fri, 25 Mar 2005 20:55:09 +0100 (MET)
From: "Andrus Moor" <nospameetasoftnospam@online.ee>
X-Newsgroups: pgsql.sql
Subject: select a list of schema names
Date: Fri, 25 Mar 2005 21:50:18 +0200
Organization: Hub.Org Networking Services
Lines: 11
Message-ID: <d21q20$26ut$1@news.hub.org>
X-Complaints-To: usenet@news.hub.org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.254 tagged_above=0 required=5 tests=AWL,
	PRIORITY_NO_NAME
X-Spam-Level: *
X-Archive-Number: 200503/349
X-Sequence-Number: 20828

I want to implement a multi-company database where each schema represents 
different company.

I created a number of schemas in a database.

How to select a list of schema names which current user is authorized to 
access ?

I want to get the list of companies to allow user pick the one.