Any advice on access to these tables and views. Specifically the pg_timezone_names.

It is located here:

Catalogs PostgreSQL Catalog (pg_catalog) Views pg_timezone_names

Would be nice to just include this in with the schema (public)

I am not seeing it in the LLBLGEN IDE, which seems to only include Schema and not Catalog.

Best,

Jon

We support 1 catalog per database for postgresql, so you can't include multiple catalogs in one project. This is a system catalog btw, not sure what you want to use it for, but you could create a view in your normal schema which does a select on pg_timezone_names and that view will then be visible in the project.

Frans,

Thanks for the response. The view will work just fine. They have a list of all timezones in the pg_timezone_names view that I really wanted access to.

I created a view and it appears to work as designed.

Thanks again,

jon