Thread: system object display option?

system object display option?

From
"George Pavlov"
Date:
this might be a bug or me misunderstanding how things work (in which
case please help). in pgadmin 1.6.* selecting view/system objects
results in system objects (such as the information_schema and pg_catalog
schemas) showing in the tree view. i am guessing that for 1.8 the
equivalent functionality is under file/options/display. i have "show
system objects in the treeview" checked and schemas is checked in the
list of objects to display, but my information_schema and pg_catalog
schemas are not showing (pg_toast and pg_temp_x are showing though). i
am on 1.8.0 beta 5.

george


Re: system object display option?

From
Guillaume Lelarge
Date:
George Pavlov a écrit :
> this might be a bug or me misunderstanding how things work (in which
> case please help). in pgadmin 1.6.* selecting view/system objects
> results in system objects (such as the information_schema and pg_catalog
> schemas) showing in the tree view. i am guessing that for 1.8 the
> equivalent functionality is under file/options/display. i have "show
> system objects in the treeview" checked and schemas is checked in the
> list of objects to display, but my information_schema and pg_catalog
> schemas are not showing (pg_toast and pg_temp_x are showing though). i
> am on 1.8.0 beta 5.
> 

You also need to have catalogs checked in File/Options/Display. In
pgAdmin 1.8, information_schema and pg_catalog are on the Catalogs node.

Regards.


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com