我尝试使用以下RunSQL
命令运行迁移:
class Migration(migrations.Migration):
operations = [
RunSQL(
r'''
COPY auth_group (id, name) FROM stdin;
1 TEST-GROUP
\.
''')]
它会出现以下这种失败情况:
File "/home/foo/local/lib/python2.7/site-packages/django/db/backends/utils.py", line 63, in execute
return self.cursor.execute(sql)
django.db.utils.ProgrammingError: syntax error at or near "1"
LINE 3: 1 TEST-GROUP
< p >在< code >RunSQL中是否不允许使用< code >COPY?< /p >
< p >我们使用psycopg2< /p >
psql -f myfile.sql
运行。对于新手来说,这两种用法看起来非常相似。 - guettli