Re: BEGIN/END in SQL generated by pgAdmin ERD command

2025-06-03 Thread Marc Linster
Thanks Dave - I had an error message, but it turned out that was related to my code. M. --- Marc Linster; m...@marclinster.com; https://www.linkedin.com/in/marclinster; https://marclinster.medium.com +352 621 430 156 On Mon, Jun 2, 2025 at 4:46 PM Dave Page

BEGIN/END in SQL generated by pgAdmin ERD command

2025-06-02 Thread Marc Linster
When I ask pgAdmin 9.4 to generate SQL from the ERD window, it wraps 'BEGIN;' and 'END;' around the set of statements, instead of 'BEGIN;/COMMIT;'. This is for pgAdmin 9.4 on Sequoia 15.5 Am I missing something? Thanks, Marc ---------

Re: Object Explorer not showing when opening PSQL or Query Tool

2025-05-12 Thread Marc Linster
Thank you Anil - I had totally forgotten that I changed the workspace setting on my Mac. Thank you for the quick and helpful response, Marc - Marc Linster, Ph.D.; Technology Strategist (+352) 621 430 156 https://www.linkedin.com/in/marclinster/ > On 12 May 2025, at 09

Object Explorer not showing when opening PSQL or Query Tool

2025-05-12 Thread Marc Linster
On MacOS, the object browser shows right next to the query tool. On Windows 11, pgAdmin 9.0 the object browser always closes when I create a new PSQL or Query Tool. Am I missing something? Thanks for the help Marc --- Marc Linster; m...@marclinster.com; https

Re: Clearing the screen in the pgAdmin PSQL screen

2025-04-21 Thread Marc Linster
\! clear (with space before clear works like a charm). Thank you, Marc --- Marc Linster; m...@marclinster.com; https://www.linkedin.com/in/marclinster; https://marclinster.medium.com +352 621 430 156 On Mon, Apr 21, 2025 at 9:04 AM Andy Huang <258790...@qq.

Re: Clearing the screen in the pgAdmin PSQL screen

2025-04-20 Thread Marc Linster
r postgres-# ; ERROR: syntax error at or near "/!" LINE 1: /!clear ^ postgres=# /!clear; ERROR: syntax error at or near "/!" LINE 1: /!clear; ^ postgres=# l postgres-# ; ERROR: syntax error at or near "l" LINE 1: l ^ postgres=#

Clearing the screen in the pgAdmin PSQL screen

2025-04-20 Thread Marc Linster
The Query Tool has a feature to clear the screen (Option/Alt + Ctrl + L). Does the PSQL Tool have something similar? Thanks, Marc --- Marc Linster; m...@marclinster.com; https://www.linkedin.com/in/marclinster; https://marclinster.medium.com +352 621 430 156