creating a table in plpython?

On Wed, Jan 10, 2018 at 4:27 PM, Celia McInnis <celia.mcinnis@gmail.com>
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.
​

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@gmail.com> wrote: