insert DEFAULT value

From: Hans Ginzel <hans(at)matfyz(dot)cz>
To: psycopg(at)postgresql(dot)org
Subject: insert DEFAULT value
Date: 2021-03-03 21:51:37
Message-ID: 20210303215137.GI11758@artax.karlin.mff.cuni.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

How to insert DEFAULT value, please?

import psycopg2
from psycopg2.sql import DEFAULT # https://www.postgresql-archive.org/Inserting-default-values-into-execute-values-td6130148.html

db = psycopg2.connect(host='host', dbname='db')
cursor = db.cursor()
cursor.execute("DROP TABLE IF EXISTS test_default")
cursor.execute("CREATE TABLE test_default(i int NOT NULL DEFAULT 1)")
cursor.execute("INSERT INTO test_default VALUES (%s)", (DEFAULT,))

cursor.execute("DROP TABLE IF EXISTS test_default")
cursor.execute("CREATE TABLE test_default(j jsonb NOT NULL DEFAULT '{}'::jsonb)")
cursor.execute("INSERT INTO test_default VALUES (%s)", (DEFAULT,))

For both cases I get
psycopg2.ProgrammingError: can't adapt type 'SQL'

Thank you in advance,
HG

Responses

Browse psycopg by date

  From Date Subject
Next Message Adrian Klaver 2021-03-03 23:23:28 Re: insert DEFAULT value
Previous Message Federico Di Gregorio 2021-02-24 16:13:38 Re: License LPGL and commercialization