Re: Send multiple statements to pg server at once

2025-03-11 Thread Andy Fan
Pavel Stehule writes: > > If I remember well, you can use \; for this case > > https://www.postgresql.org/docs/current/app-psql.html > > Regards Thank you Pavel, it works! This is so handy! -- Best Regards Andy Fan

Re: Send multiple statements to pg server at once

2025-03-11 Thread Pavel Stehule
Hi Ășt 11. 3. 2025 v 8:23 odesĂ­latel Andy Fan napsal: > > > Hi, > > I want to simulate a case where server receive "SELECT 1;SELECT 2;" at > once, so when executing exec_simple_query, the query_string is > "SELECT 1;SELECT 2;" However I found it is not easy to simulate, does > anyone has a sugge

Send multiple statements to pg server at once

2025-03-11 Thread Andy Fan
Hi, I want to simulate a case where server receive "SELECT 1;SELECT 2;" at once, so when executing exec_simple_query, the query_string is "SELECT 1;SELECT 2;" However I found it is not easy to simulate, does anyone has a suggestion? I tried 'psql -f', checking 'psql/settings.h', at last I see