[sqlalchemy] Re: Using psql commands (i.e. \d) through sqlalchemy.core
Thank you Jonathan and Lele! I'll look at pgspecial, looks like I will be able to use it. Ciao! Ugo On Monday, October 31, 2016 at 3:07:41 PM UTC-4, Lele Gaifax wrote: > > Jonathan Vanasco > writes: > > > I believe the answer is no. > > > > IIRC, those psql commands are shortcuts within psql... and the various > > drivers (psycopg2, etc) don't support them. > > Right. Some of those commands are exposed by > https://pypi.python.org/pypi/pgspecial, used for example by pgcli, a > Python-based alternative to psql. > > ciao, lele. > -- > nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri > real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia. > le...@metapensiero.it | -- Fortunato > Depero, 1929. > > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
[sqlalchemy] Re: Using psql commands (i.e. \d) through sqlalchemy.core
Jonathan Vanasco writes: > I believe the answer is no. > > IIRC, those psql commands are shortcuts within psql... and the various > drivers (psycopg2, etc) don't support them. Right. Some of those commands are exposed by https://pypi.python.org/pypi/pgspecial, used for example by pgcli, a Python-based alternative to psql. ciao, lele. -- nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia. l...@metapensiero.it | -- Fortunato Depero, 1929. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
[sqlalchemy] Re: Using psql commands (i.e. \d) through sqlalchemy.core
I believe the answer is no. IIRC, those psql commands are shortcuts within psql... and the various drivers (psycopg2, etc) don't support them. A workaround is to use the underlying query against postgresql's tables (http://stackoverflow.com/questions/31532489/meta-commands-in-psycopg2-d-not-working) . `Connection` and `Engine` objects have an `execute()` command. `execute` accepts a "statement" that can be raw sql, so you can stuff the sql query in there. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
