Re: How not to display system tables? - Mailing list pgsql-novice

From Ennio-Sr
Subject Re: How not to display system tables?
Date
Msg-id 20050609231819.GA9950@deby.ei.hnet
Whole thread Raw
In response to Re: How not to display system tables?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
* Tom Lane <tgl@sss.pgh.pa.us> [090605, 18:03]:
> Ennio-Sr <nasr.laili@tin.it> writes:
> > thanks for the quick answer. AAMOF I did try pgAdmin months ago (when I
> > was running pg 7.2). Now I'm using 7.4.7-6sarge1 version and
> > occasionally pgAccess. Might this one be responsible for that also?
> > Can I simply cancel those pga*'s?
>
> Very possibly it's pgAccess that made them.  You could drop those tables
> from psql and then see which tool recreates them when you start it ...
>
>             regards, tom lane

I dropped the pga_* tables as suggested, started pgAccess, viewed some
tables on the various databases, closed pgAccess, went to psql mydb and
could see that no pga_* table had been created (for the time being :-)
); so the 'culprit' must have been pgAdmin. May be pgAccess is
responsible for creating some sql_* tables, however these are not listed
by the \d command.
Should I find out something differewnt in the future I'll advise the
list.
Thanks again, Tom.
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) ]

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: How not to display system tables?
Next
From: Havasvölgyi Ottó
Date:
Subject: need suggestion for server sizing