pg_tables and schemas

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_tables and schemas
Date: 2002-07-09 09:26:03
Message-ID: GNELIHDDFBOCMGBFGEFOMEAMCDAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom,

Does the pg_tables view need to be fixed now that we have schemas?

Yep:

test2=# create schema a;
CREATE SCHEMA
test2=# create schema b;
CREATE SCHEMA
test2=# create table a.test (a int4);
CREATE TABLE
test2=# create table b.test (b int4);
CREATE TABLE
test2=# select * from pg_tables where tablename not like 'pg_%';
tablename | tableowner | hasindexes | hasrules | hastriggers
-----------+------------+------------+----------+-------------
test | chriskl | f | f | f
test | chriskl | f | f | f
(2 rows)

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Iavor Raytchev 2002-07-09 10:36:32 pgaccess update
Previous Message Christopher Kings-Lynne 2002-07-09 08:31:57 Postgres Projects