Re: is it possibile get the psql prompt output?

From: Federico Di Gregorio <fog(at)dndg(dot)it>
To: psycopg(at)postgresql(dot)org
Cc: Ottavio Campana <ottavio(at)campana(dot)vi(dot)it>
Subject: Re: is it possibile get the psql prompt output?
Date: 2012-05-16 07:24:18
Message-ID: 4FB35622.4080101@dndg.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

On 16/05/12 09:06, Ottavio Campana wrote:
> I am writing a small python script and I'd like to get the output I
> would get as if I executed the commands from psql. Let's make an
> example, suppose you have a small table such as
>
> create table xxx_test (
> id serial,
> description text);
>
> and that you perform this command in psql
>
> mydb=# INSERT INTO xxx_test values (default, 'ciao');
> INSERT 0 1
> mydb=#
>
> In python I do
>
> cursor = connection.cursor ()
> cursor.execute (command)
> connection.commit ()
>
> with command being the insert command. Now the question is: is there a
> way to get the "INSERT 01" back?

You can't because that's generated by psql on the client and it isn't
from the server. You can get the number of affected rows from the
cursor, after the .execute().

federico

--
Federico Di Gregorio federico(dot)digregorio(at)dndg(dot)it
Studio Associato Di Nunzio e Di Gregorio http://dndg.it
In science one tries to tell people, in such a way as to be understood
by everyone, something that no one ever knew before. But in poetry,
it's the exact opposite. -- Paul Dirac

In response to

Browse psycopg by date

  From Date Subject
Next Message Egbert Bouwman 2012-05-16 08:17:49 Re: is it possibile get the psql prompt output?
Previous Message Ottavio Campana 2012-05-16 07:06:56 is it possibile get the psql prompt output?