On Wed, 9 Dec 2020, Paul Förster wrote:
maybe you're looking for this? https://stackoverflow.com/a/7389606
Paul, That looks very useful and I'll try the provided answers. Looking at the postgres-12 doc I cannot find a command 'PROMPT' anywhere in it. Thanks, Rich