Re: How not to display system tables?

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

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [090605, 18:03]:
> Ennio-Sr <nasr(dot)laili(at)tin(dot)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) ]

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Havasvölgyi Ottó 2005-06-10 21:12:56 need suggestion for server sizing
Previous Message Tom Lane 2005-06-09 22:03:12 Re: How not to display system tables?