gexec from command prompt?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: gexec from command prompt?
Date: 2023-01-12 17:25:00
Message-ID: 00a37956-d2b1-3749-9747-66d0d562ac90@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Postgresql 12.11

This might be more of a bash question, or it might be a psql vs engine problem.

I want to run this query using psql from a bash prompt:
select format('SELECT ''%s'', MIN(part_date) FROM %s;', table_name, table_name)
from dba.table_structure
order by table_name\gexec

Thus, I added an extra back

$ psql sides -atXc "select format('SELECT ''%s'', MIN(part_date) FROM %s;',
table_name, table_name) from dba.table_structure order by table_name limit
5\\gexec"
select format('SELECT ''%s'', MIN(part_date) FROM %s;', table_name,
table_name) from dba.table_structure order by table_name limit 5\gexec
ERROR:  syntax error at or near "\"
LINE 1: ...) from dba.table_structure order by table_name limit 5\gexec

Removing "\\exec" from the statement, and appending -c "\\gexec" to the psql
command technically worked, but did not run the commands.

--
Born in Arizona, moved to Babylonia.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2023-01-12 17:33:59 Re: gexec from command prompt?
Previous Message Ron 2023-01-12 17:12:48 Re: AW: [Extern] Re: postgres restore & needed history files