Date: Thu, 4 Mar 2021 06:43:28 +0100
From: Hans Ginzel <hans@matfyz.cz>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: psycopg@postgresql.org
Subject: Re: insert DEFAULT value
Message-ID: <20210304054327.GL11758@artax.karlin.mff.cuni.cz>
References: <20210303215137.GI11758@artax.karlin.mff.cuni.cz>
 <05f8e563-162a-3a86-d939-7fb7f03811e6@aklaver.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Disposition: inline
In-Reply-To: <05f8e563-162a-3a86-d939-7fb7f03811e6@aklaver.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
Archived-At: 
 <https://www.postgresql.org/message-id/20210304054327.GL11758%40artax.karlin.mff.cuni.cz>
Precedence: bulk

On Wed, Mar 03, 2021 at 03:23:28PM -0800, Adrian Klaver wrote:
>On 3/3/21 1:51 PM, Hans Ginzel wrote:
>You need to do something like:
>cur.execute(sql.SQL("INSERT INTO test_default VALUES ({})").format(DEFAULT))

Formating values into SQL statement is done by the execute(), isn't it?

I like the solution from
https://www.postgresql-archive.org/Inserting-default-values-into-execute-values-td6130148.html

https://www.postgresql-archive.org/Inserting-default-values-into-execute-values-td6130148.html

class Default(object):
   """Set up DEFAULT value for a field.

   When doing INSERT or UPDATE in Postgres one can use DEFAULT/default
   as the value to have the server use the default set on the field.
   """
   def __conform__(self, proto):
     if proto is psycopg2.extensions.ISQLQuote:
       return self
   def getquoted(self):
     return 'DEFAULT'

DEFAULT = Default()

cursor.execute("INSERT INTO test_default VALUES (%s)", (DEFAULT,))

Could this be added to the psycopg2 code, please?

H.