X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B836AD1BB90 for ; Mon, 1 Dec 2003 07:15:52 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 53153-05 for ; Mon, 1 Dec 2003 03:15:22 -0400 (AST) Received: from guadiana.unex.es (guadiana.unex.es [158.49.17.23]) by svr1.postgresql.org (Postfix) with ESMTP id 2A17ED1B4A7 for ; Mon, 1 Dec 2003 03:15:20 -0400 (AST) Received: from alberto by guadiana.unex.es with local (Exim 3.35 #1 (Debian)) id 1AQiH0-0006dp-00; Mon, 01 Dec 2003 08:15:10 +0100 Date: Mon, 1 Dec 2003 08:15:10 +0100 To: Kenneth Suralta Cc: pgsql-interfaces@postgresql.org Subject: Re: libpq question.. Message-ID: <20031201071510.GA25177@guadiana.unex.es> References: <3FCAD608.4020001@hq.ntsp.nec.co.jp> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <3FCAD608.4020001@hq.ntsp.nec.co.jp> User-Agent: Mutt/1.3.28i From: Alberto Cabello Sanchez X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/2 X-Sequence-Number: 4611 > Does anybody know how to determine the user-defined tables > in a database using C (libpq) ??? You can query the database: SELECT tablename FROM pg_tables WHERE tablename NOT LIKE 'pg_%' and browse the result. Hope this helps. -- ----------------------- Alberto Cabello Sánchez alberto@unex.es Servicio de Informática 924 289 351 -----------------------