Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 14D5419DE834 for ; Wed, 7 Mar 2012 11:40:09 -0400 (AST) Received: from locust.cns.ipv6.vt.edu ([2001:468:c80:210f:211:43ff:fee7:4af5] helo=locust.cns.vt.edu) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S5IyA-00015V-S6 for pgsql-admin@postgresql.org; Wed, 07 Mar 2012 15:40:08 +0000 Received: by locust.cns.vt.edu (Postfix, from userid 986) id 0FB14118DE6; Wed, 7 Mar 2012 10:39:48 -0500 (EST) Date: Wed, 7 Mar 2012 10:39:48 -0500 From: Ray Stell To: pgsql-admin@postgresql.org Subject: table names seem identical Message-ID: <20120307153948.GA24033@cns.vt.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.17 (2007-11-01) X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/24 X-Sequence-Number: 39212 how I can differentiate these: oamp=# \z public.c3* Access privileges Schema | Name | Type | Access privileges | Column access privileges --------+-----------------------+-------+-------------------+-------------------------- public | c3p0_connection_test | table | | public | c3p0_connection_test | table | | (2 rows) oamp=# select * from pg_tables where tablename = 'c3p0_connection_test'; schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers ------------+----------------------+------------+------------+------------+----------+------------- public | c3p0_connection_test | admin | | f | f | f (1 row) oamp=# select version(); version ------------------------------------------------------------------------------------------------------------ PostgreSQL 9.0.7 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51), 32-bit (1 row)