Re: creating a table in plpython?

[Celia McInnis <celia.mcinnis@xxxxxxxxx>]

Thanks - works like a charm. Hmmm. I tried that earlier and got errors. I just retried and it worked fine this time. I guess I had some other problem - It seems that sometimes I have to exit and reenter my psql session to use a newly interpreted version of my stored procedure, so maybe that was part of the problem...

On Wed, Jan 10, 2018 at 6:34 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Wed, Jan 10, 2018 at 4:27 PM, Celia McInnis <celia.mcinnis@xxxxxxxxx> wrote:

Hi - Is it possible to create a table inside a plpython stored procedure? If so, can you give an example of how to do so?

​Haven't used pl/python myself but...​

​https://www.postgresql.org/docs/10/static/plpython-database.html

so... plpy.execute("CREATE TABLE ...") ?

David J.

​