alternatives - Search results in mailing lists

2024-12-06 05:15:43 | Re: Parameter in SQL query being misinterpreted (Adrian Klaver)

alternative I keep forgetting about, the function make_interval(): https:///docs/current/functions-datetime.html make_interval ( [ years int [, months

2021-02-08 12:16:43 | Re: Latest developments in psycopg3 (Daniele Varrazzo)

alternative record factories. We can review if the best way is to create cursor subclasses

2021-02-04 11:16:47 | Re: about client-side cursors (Denis Laxalde)

Alternatively (or in complement), how about renaming connection.cursor() as connection.client() for client-side

2020-11-07 16:32:39 | psycopg3 and adaptation choices (Daniele Varrazzo)

alternative: ``text``) - cast Python ``int`` to ``numeric`` by default (alternatives: ``int4``, ``int8``, ``unknown``). Being the adaptation

2019-04-04 13:05:52 | Psycopg 2.8 released (Daniele Varrazzo)

alternative to Python's builtin datetime. - No longer use 2to3 during installation for Python 2 & 3 compatibility

2018-01-23 20:52:42 | Re: Calling stored procredure from psycopg2 (Ed Behn)

Alternatively, you can explicitly reference the schema in your query. (ie SELECT *schema_name*.func

2017-07-22 21:46:08 | Re: [psycopg] UPDATE command (Jonathan Rogers)

alternative column-list syntax for UPDATEs but that's not quite like an INSERT. Your

2016-05-24 10:58:59 | Re: Pass parameters to cursor.execute('Listen ')? (Daniele Varrazzo)

Alternatively you may write a plpgsql function listen(channel text) taking the argument as a string

2016-03-02 10:20:43 | Re: Problem with psycopg2 and asyncio (Frank Millman)

alternative connection that uses sqlite3, but then I do have to comment/uncomment to switch databases

2015-04-24 14:06:56 | Possible reasons for copy_from to never terminate? ()

look for the cause? Alternatively, is it possible to simply put a timeout on the copy? -Daniel

2013-12-31 21:30:23 | Re: Insert with a lot of columns (Adrian Klaver)

Another alternative would be to use the psycopg COPY methods: http:///psycopg/docs/usage.html#copy -- Adrian Klaver adrian.klaver@gmail.com

2013-12-26 13:37:59 | Re: Resdhift's lack of cursors and PQsetSingleRowMode (Marko Kreen)

alternative cursor object? Integraring with existing cursor implementation might create too much complexity perhaps? No, libpq

2013-11-28 17:41:39 | Re: Building on Win7 x64 for python2.6.4 x64 DLL load failed Error (Daniele Varrazzo)

/questions/4676433/solving-dll-load-failed-1-is-not-a-valid-win32-application-for-pygame Particularly interesting is this resource: http:///~gohlke/pythonlibs/#psycopg offering alternative win builds of psycopg. -- Daniele

2013-08-01 15:45:48 | Re: Problem with the default registration of the JSON adapter (Daniele Varrazzo)

alternatives. Without assumption of what people does or doesn't do with their data, JSON

2012-09-22 13:25:27 | Re: flexi adaption/casting scheme (Tobias Oberstein)

Alternatively, without breaking the API: @classmethod def _from_db(self, name, conn_or_curs): ... c = CompositeCaster