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) -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
