foo> - Search results in mailing lists
Mailing lists >> psycopg >> Thread
2024-11-01 19:49:05 | Re: TypeError: dict is not a sequence (thiemo@gelassene-pferde.biz)
foo UNION ALL SELECT 2 AS rid, ST_FromGDALRaster(png, 3310) AS rast FROM foo ) SELECT
Mailing lists >> psycopg >> Thread
2024-02-14 01:37:32 | Reporting UnicodeEncodeError info on arbitrary data sent to PG with psycopg3 (Karl O. Pinc)
foo (col1 text, col2 text, col3 text); Mock up of desired code (only slightly mangled
Mailing lists >> psycopg >> Thread
2023-07-20 20:39:46 | Re: conn.read_only not honored in autocommit mode (Daniele Varrazzo)
foo ()") Traceback (most recent call last) ... ReadOnlySqlTransaction: cannot execute CREATE TABLE in a read-only
Mailing lists >> psycopg >> Thread
2021-10-13 13:11:14 | Using standard SQL placeholders in PG (Lembark, Steven)
foo from bar where bletch = $1 is valid SQL. The doller-notation allows re-use of positional
Mailing lists >> psycopg >> Thread
2020-12-02 13:56:31 | Re: Executing on the connection? (Daniele Varrazzo)
foo=%s)", ["bar", baz]).fetchone() This is pretty much the most efficient thing that can be done
Mailing lists >> psycopg >> Thread
2016-02-19 23:34:46 | PQntuples for older version (2.2.1) of psycopg2 with ctypes (Alan Evans)
foo) cursor = conn.cursor() cursor.copy_expert(bar) rowcount = libpq.PQntuples(???) I can "read" the psycopg2
Mailing lists >> psycopg >> Thread
2013-10-08 16:19:52 | Re: Is passing a list as a bound variable safe from SQL injection? (Stuart Bishop)
foo SET bar='baz' WHERE id IN ([... 10,000 ids ...])' without breaking a sweat, even
Mailing lists >> psycopg >> Thread
2012-11-26 11:52:03 | Re: cursor.executemany generates multiple INSERTs (Daniele Varrazzo)
foo values " + ','.join(["%s"] * len(data)), data) Out[18]: "insert into foo values ('B6717', 'Tampopo
Mailing lists >> psycopg >> Thread
2012-09-27 07:19:21 | Re: Session state per transaction (Federico Di Gregorio)
foo", "bar")) prep.execute(("baz", "gaz")) prep.connection.commit() Yes, we can probably have prepared
Mailing lists >> psycopg >> Thread
2012-09-21 17:40:18 | Re: flexi adaption/casting scheme (Daniele Varrazzo)
foo', 44, ARRAY[1, 2, 3], NULL, ('Duckhausen', NULL, 18, ARRAY[(10, NULL, 'blub'), (NULL
Mailing lists >> psycopg >> Thread >> Search in thread (2)
2011-11-16 16:50:47 | Re: RFC: Extend psycopg2.connect to accept all valid parameters? (Daniele Varrazzo)
foo') In [17]: cur = cnn.cursor() In [19]: cur.execute("select application_name from pg_stat
Mailing lists >> psycopg >> Thread >> Search in thread (2)
2011-06-24 16:05:15 | Unpacking a Python list in a query. (Sukhbir Singh)
Foo", "Bar"] So, I want to execute the complete query as: substituting element by element
Mailing lists >> psycopg >> Thread
2011-05-11 11:30:43 | Re: Input and Output data traffic (Oswaldo)
foo (a,b,c) values(1,2,3);" * 1000) # 1000 calls, each time an insert
Mailing lists >> psycopg >> Thread >> Search in thread (3)
2011-04-08 15:03:08 | Re: portable DBAPI auto-increment (Mark Sienkiewicz)
foo ( k serial, v varchar(10) ); NOTICE: CREATE TABLE will create implicit sequence "foo_k_seq" for serial
Mailing lists >> psycopg >> Thread >> Search in thread (2)
2011-02-28 17:27:57 | Re: Using real libpq parameters (Daniele Varrazzo)
foo)s, %(bar)s, %(foo)s" would become "SELECT $1, $2, $1" plus a remapping