How not to display system tables?

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: How not to display system tables?
Date: 2005-06-09 19:39:46
Message-ID: 20050609193946.GA8532@deby.ei.hnet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all!
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 = ...).
I tried \d !~pga* to no avail ;(
Regards,
Ennio.

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Celia McInnis 2005-06-09 19:42:21 returning multiple values from a plpgsql function?
Previous Message Daniel T. Staal 2005-06-09 18:56:47 Function debugging question