Postgres Pro
Downloads
Home   >   mailing lists

Re: creating a table in plpython? - Mailing list pgsql-general

From Celia McInnis
Subject Re: creating a table in plpython?
Date
Msg-id CAGD6t7+b9uQ2c99VTugObffVFiL6k98q22e8Rmd-FxZSu6ApMQ@mail.gmail.com
Whole thread Raw
In response to Re: creating a table in plpython?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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:
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.
​

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: creating a table in plpython?
Next
From: Andreas 'ads' Scherbaum
Date:
Subject: FOSDEM booth volunteer