diff options
| -rw-r--r-- | database.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/database.py b/database.py index 5119899..41f4328 100644 --- a/database.py +++ b/database.py @@ -42,7 +42,7 @@ class Database(object): async with self._pool.acquire() as conn: async with conn.transaction(): await conn.execute("CREATE TABLE IF NOT EXISTS " + objtype + - " (id TEXT PRIMARY KEY, data json)") + " (id TEXT PRIMARY KEY, data jsonb)") await conn.executemany("INSERT INTO " + objtype + " " + "VALUES ($1, $2) " + "ON CONFLICT (id) DO " + @@ -92,7 +92,7 @@ class Database(object): async with self._pool.acquire() as conn: async with conn.transaction(): await conn.execute("CREATE TABLE IF NOT EXISTS meta " + - "(key TEXT PRIMARY KEY, value json)") + "(key TEXT PRIMARY KEY, value jsonb)") if value is not None: value = json.dumps(value) await conn.execute("INSERT INTO meta(key, value) " + |