Ask Your Question
0

How can I hide the information_schema and pg_catalog tables?

asked 2012-06-08 16:37:41 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >750 is welcome to improve it.

updated 2012-06-08 16:37:41 +0200

anonymous user

Anonymous

I'd like to hide the above tables from the user interface when accessing a PostgreSQL database. Is there a way I can filter, or choose which tables I'm interested in?

delete close flag offensive retag edit

1 Answer

Sort by » oldest newest most voted
1

answered 2012-07-23 11:56:46 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >750 is welcome to improve it.

updated 2012-07-23 11:56:46 +0200

Alex Thurgood gravatar image Alex Thurgood
166 8 3

Open your ODB file that connects to your postgres db server. From the Tools menu, choose Table Filter.

Select the Tables you want to hide by unclicking them - the main db entry will still be visible, but the user won't be able to drill down through the table entries. This works for mysql, but I haven't tried it with postgresql.

Alex

link delete flag offensive edit

Comments

Anon -- Does this answer help you? Still looking for an answer to this question?

qubit ( 2013-03-13 10:34:29 +0200 )edit

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow

subscribe to rss feed

Stats

Asked: 2012-06-08 16:37:41 +0200

Seen: 223 times

Last updated: Jul 23 '12