Re: Send multiple statements to pg server at once - Mailing list pgsql-hackers

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 below code
in psql/mainloop.c, I guess it is impossible in psql.


        /*
         * Send command if semicolon found, or if end of line and we're in
         * single-line mode.
         */
        if (scan_result == PSCAN_SEMICOLON ||
                (scan_result == PSCAN_EOL && pset.singleline))
        {

--
Best Regards
Andy Fan