F2

2022-01-14 Thread Richard Greenwood
Out of habit, I sometimes hit F2 (the rename key in many programs) when I'm renaming database objects. This causes the left side browser panel to go blank and I can't figure out how to get it back without restarting pgAdmin or resetting the layout, which is pretty nearly the same. So what's the poi

Re: SQL query that can be used to generate the same output shown in the SQL tab within pgadmin?

2022-01-14 Thread Frank Gard
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 va