python - ProgrammingError：无法适应类型“MaskedArray”

Question

我在将数据类型为 MaskedArray 的数据插入 postgresql 时遇到问题。我收到错误 ProgrammingError：无法适应类型“MaskedArray”。有没有办法将这些数据输入到 postgresql 中？这是我的代码：

import import psycopg2 
from netCDF4 import Dataset
import numpy as np
import numpy.ma as ma
import matplotlib.pyplot as plt
import cartopy.crs as ccrs
import pyodbc

#Establishing the connection
conn = psycopg2.connect( database='', user='', password='', host='', port='')

#Setting auto commit false
conn.autocommit = True
url = "http://182.16.248.173:8080/dods/INA-NWP/2021030100/2021030100-d02-asim"
file = Dataset(url)

rainc = file.variables['rainc'][7,0,:,:]

#Creating a cursor object using the cursor() method
cursor = conn.cursor()

sql = "INSERT INTO test (id, var1) VALUES (%s, %s)"
data = ('2', rainc)

cursor.execute(sql, data)

#Commit your changes in the database
conn.commit()
print("Records Inserted")

标签： pythonpostgresqlpostgismasked-array