Hi,
what about using the output of "pg_dump"?
There are good chances to find a set of cli-options or a workflow that can
produce all SQL statements to exactly reproduce your views.
Cheers,
Frank.
PS: Here some "real world example":
franktest=# create table testtab (id integer, something
Please see the following Perl module we have developed. Maybe someone
can incorporate this directly into postgres someday so we can do 'SHOW
CREATE TABLE' and etc from any client and get the DDL.
This won't run out of the box for you as there are other modules we use
internally that are not
Hi
On Wed, Jan 12, 2022 at 12:45 AM Ni Ne wrote:
> My question is not specifically about how to use pgadmin, I hope that's
> okay.
>
> When are you in pgadmin you can select an object from the tree on the
> left-pane, like a View. While that object is selected, if you click the SQL
> button in
My question is not specifically about how to use pgadmin, I hope that's okay.
When are you in pgadmin you can select an object from the tree on the
left-pane, like a View. While that object is selected, if you click the SQL
button in the main-pane toolbar, you can see all SQL commands that were