popen2 psql

[Mage]

Hello,

maybe my question is about linux and not about python.

I tried to write a proxy script for "psql" command. I need some query
log. I failed to read from the file object.

I have tested:

a,b = os.popen2('ls')
for s in b.readlines(): print s,

and:

a,b = os.popen2('./pto.py')
for s in b.readlines(): print s,

popen2 works with 'ls' but it doesn't output anything with the './pto.py'.
The 'pto.py' is an existing python script and contains some print.

Likely I have the same problem with popening the python script and the
psql binary. I can simple popen('psql').write(), but I would like to log
everything, so I need stdin and stdout files.

Please help.

Mage

[Klaus Alexander Seistrup]

Mage wrote:

I tried to write a proxy script for "psql" command. I need some
query log. I failed to read from the file object.

The psql command is probably linked against readline; did you look
in the ~/.psql_history file?

Cheers,

--
Klaus Alexander Seistrup
Magnetic Ink, Copenhagen, Denmark
http://magnetic-ink.dk/

[Mage]

Klaus Alexander Seistrup wrote:

Mage wrote:

I tried to write a proxy script for "psql" command. I need some
query log. I failed to read from the file object.

The psql command is probably linked against readline; did you look
in the ~/.psql_history file?

Thank you. I will check but what about the python scripts? Why can't I
read their *print* output with popen2?

Mage