Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

psycopg by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group