Thread: catalog location

Please, I need to know where the catalog tables (pg_class, pg_attrdef...) are located in the postgresql rdbms. Because I can not see them in the pgAdminII interface, like other tables or objects. And I can not find any reference about where this information is, please any help would be welcome.

Also I'd like to know if these catalog classes are owned by the superuser (I defined it when I installed ) or all the users could access to them and perhaps modify them.

Thanks,

Carmen

---

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com

On Jul 7, 2007, at 8:16 AM, Carmen Martinez wrote:

> Please, I need to know where the catalog tables (pg_class,
> pg_attrdef...) are located in the postgresql rdbms. Because I can
> not see them in the pgAdminII interface, like other tables or
> objects. And I can not find any reference about where this
> information is, please any help would be welcome.

These are located in the pg_catalog schema. pgAdmin III (don't know
about II) can show them if you turn on the "System Objects" menu item
in the View menu. The tables are documented in the PostgreSQL manual.

>
> Also I'd like to know if these catalog classes are owned by the
> superuser (I defined it when I installed ) or all the users could
> access to them and perhaps modify them.

All users can see them. You should not modify them directly.




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL