<!doctype html>
<html>
<head>
<meta charset="UTF-8">
</head>
<body>
<div class="default-style">
<div class="default-style">
Hi,
</div>
<div class="default-style">
<br>
</div>
<div class="default-style">
In pgAdmin4 you can view the query needed to create a table, view, etc. by selecting the SQL tab.
<br>I assume in pgAdmin4 this SQL view is build using a query.
<br>Is it possible to publish this query. Probably this query is something like this:
<br>
</div>
</div>
<div class="io-ox-signature">
<div class="default-style">
<br>
</div>
<div class="default-style">
SELECT 'CREATE OR REPLACE VIEW ' || pg_views.schemaname || '.' || pg_views.viewname || ' AS ' || chr(10) ||
<br>pg_views.definition || chr(10) ||
<br>'ALTER TABLE ' || pg_views.schemaname || '.' || pg_views.viewname || ' OWNER TO ' || pg_views.viewowner || ';' ||
<br>chr(10) || 'COMMENT ON VIEW ' || pg_views.schemaname || '.' || pg_views.viewname|| chr(10) ||
<br>' IS ''' || CASE WHEN obj_description(pg_class.oid) != '' THEN obj_description(pg_class.oid) ELSE 'No description' END || ''';' || chr(10)
<br>FROM pg_views
<br>JOIN pg_class ON pg_class.relname=pg_views.viewname
<br>JOIN pg_namespace ON pg_class.relnamespace=pg_namespace.oid
<br>WHERE pg_namespace.nspname = LOWER('{schema}');
<br>
</div>
<div class="default-style">
<br>
</div>
<div class="default-style">
I tried to complete the query but the only part I'm missing is the GRANT statements. It should be very helpful if I could have this query.
<br>
<br>Kind regards,
<br>
<span style="color: #ff6600;">Henk F. van Til</span>
<br>
<br>
<br>
<br>
</div>
</div>
</body>
</html>