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