top of page
Shareware software
List of tables and views of the system catalog ( pg_catalog ) of the database

SELECT oid,
relname as "Name"
FROM pg_catalog.pg_class
where relnamespace = (select oid
from pg_catalog.pg_namespace n
where nspname = 'pg_catalog')
and relkind in ('r','v','m')
order by 2
Menu
-
Copy name - copy object name to clipboard
-
Create code [select] - form the text of the query to the object (in the select phrase, the names of all fields are displayed)
-
Data - display data from the table (Data sheet tab)
bottom of page