Обсуждение: Executing \i of psql command using libpq library

Поиск
Список
Период
Сортировка

Executing \i of psql command using libpq library

От
"Edmundo Robles L."
Дата:
Hi!

How can i get the same behavior of psql -c "\\i './a_lot_of_sentences'" bd user, using the libpq library???

i tried  Pqexec(pgconn,"\\i './a_lot_of_sentences'")   but  didn't work. :(



--
SENSA Control Digital.
Ing. Edmundo Robles Lopez.
Analista Programador.





Re: Executing \i of psql command using libpq library

От
Tom Lane
Дата:
"Edmundo Robles L." <erobles@sensacd.com.mx> writes:
> How can i get the same behavior of psql -c "\\i './a_lot_of_sentences'" bd user, using the libpq library???

libpq does not contain any such behavior, so you can't.

            regards, tom lane

Re: Executing \i of psql command using libpq library

От
Josh Kupershmidt
Дата:
On Tue, Jun 14, 2011 at 11:51 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Edmundo Robles L." <erobles@sensacd.com.mx> writes:
>> How can i get the same behavior of psql -c "\\i './a_lot_of_sentences'" bd user, using the libpq library???
>
> libpq does not contain any such behavior, so you can't.

You can take a look at process_file() in psql's command.c if you're
interested to see how psql, which itself uses libpq to talk to
Postgres, implements the \i backslash command.

You haven't really explained why just having your application call out
to psql won't work. You could, of course, attempt to duplicate the
functionality of process_file() but frankly I suspect doing so would
result in a poorly implemented subset of psql.

Josh