Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 47ED719DE835 for ; Wed, 7 Mar 2012 13:42:12 -0400 (AST) Received: from plane.gmane.org ([80.91.229.3]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S5KsK-0003za-1K for pgsql-admin@postgresql.org; Wed, 07 Mar 2012 17:42:11 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1S5Ks6-0007Ue-0B for pgsql-admin@postgresql.org; Wed, 07 Mar 2012 18:41:54 +0100 Received: from cpc3-walt15-2-0-cust148.13-2.cable.virginmedia.com ([86.21.186.149]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 07 Mar 2012 18:41:53 +0100 Received: from walterhurry by cpc3-walt15-2-0-cust148.13-2.cable.virginmedia.com with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 07 Mar 2012 18:41:53 +0100 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: Walter Hurry Subject: Re: table names seem identical Date: Wed, 7 Mar 2012 17:41:41 +0000 (UTC) Lines: 27 Message-ID: References: <20120307153948.GA24033@cns.vt.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: cpc3-walt15-2-0-cust148.13-2.cable.virginmedia.com User-Agent: Pan/0.135 (Tomorrow I'll Wake Up and Scald Myself with Tea; GIT 30dc37b master) X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/29 X-Sequence-Number: 39217 On Wed, 07 Mar 2012 10:39:48 -0500, Ray Stell wrote: > 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) misc=# create table test1(flag varchar(1)); CREATE TABLE misc=# create table "test1 "(flag varchar(1)); CREATE TABLE