Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 3AE9119DE835 for ; Wed, 7 Mar 2012 14:26:27 -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 1S5LZA-00054u-LV for pgsql-admin@postgresql.org; Wed, 07 Mar 2012 18:26:25 +0000 Received: by locust.cns.vt.edu (Postfix, from userid 986) id 8D3D3118DF0; Wed, 7 Mar 2012 13:26:11 -0500 (EST) Date: Wed, 7 Mar 2012 13:26:11 -0500 From: Ray Stell To: Walter Hurry Cc: pgsql-admin@postgresql.org Subject: Re: table names seem identical Message-ID: <20120307182611.GC27195@cns.vt.edu> References: <20120307153948.GA24033@cns.vt.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.17 (2007-11-01) X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/32 X-Sequence-Number: 39220 On Wed, Mar 07, 2012 at 05:41:41PM +0000, Walter Hurry wrote: > On Wed, 07 Mar 2012 10:39:48 -0500, Ray Stell wrote: > > misc=# create table test1(flag varchar(1)); > CREATE TABLE > misc=# create table "test1 "(flag varchar(1)); > CREATE TABLE yeah, that is the case, the \z output is truncated it seems: 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 * 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)