Skip site navigation (1) Skip section navigation (2)

Re: How not to display system tables?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nasr(dot)laili(at)tin(dot)it
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How not to display system tables?
Date: 2005-06-09 20:33:57
Message-ID: 27536.1118349237@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Ennio-Sr <nasr(dot)laili(at)tin(dot)it> writes:
> Reading from man psql I see that the \d used without a pattern argument
> is equivalent to \dtvs which will display all pga_* tables along with
> the 'pure' data tables.
> Is there a way to change this behaviour (apart than using a SELECT
> relname from pg_class WHERE relkind = ...).

The pga_ tables are not system tables as far as Postgres is concerned.
IIRC they are created by some old versions of pgAdmin (or was it another
tool?)  If you move up to a more recent version you should be able to
get rid of them.

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Michael FuhrDate: 2005-06-09 21:03:22
Subject: Re: returning multiple values from a plpgsql function?
Previous:From: Tom LaneDate: 2005-06-09 20:06:58
Subject: Re: Function debugging question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group