时间戳

首页 > 解决方案 > 如何在 django 中使用 sql 文件创建 postgresql 数据库？请逐步指导我。我有如下的sql

python-3.x - 如何在 django 中使用 sql 文件创建 postgresql 数据库？请逐步指导我。我有如下的sql

问题描述

这是我要转换为 postgresql 数据库的文件的 sql 代码

CREATE TABLE banks (
        name character varying(49),
        id bigint NOT NULL
    );

--
-- Name: branches; Type: TABLE; Schema: public; Owner: siva; Tablespace: 
--

CREATE TABLE branches (
    ifsc character varying(11) NOT NULL,
    bank_id bigint,
    branch character varying(74),
    address character varying(195),
    city character varying(50),
    district character varying(50),
    state character varying(26)
);


--
-- Name: bank_branches; Type: VIEW; Schema: public; Owner: siva
--

CREATE VIEW bank_branches AS
 SELECT branches.ifsc,
    branches.bank_id,
    branches.branch,
    branches.address,
    branches.city,
    branches.district,
    branches.state,
    banks.name AS bank_name
   FROM (branches
     JOIN banks ON ((branches.bank_id = banks.id)));

然后使用标准输入有 120k 行输入

COPY banks (name, id) FROM stdin;
COPY branches (ifsc, bank_id, branch, address, city, district, state) FROM stdin;

我使用 django3.2、psycopg2.8、postgrsql 13、windows10

标签： python-3.xdatabasepostgresqlpgadmin-4django-3.0

解决方案

ERROR: character with byte sequence 0x90 in encoding "WIN1252" has no equivalent in encoding "UTF8"

对于这个错误，我将文件转换为 ANSI 并删除了记事本中 UTF8 中不可见的所有 ANSI 字符。

然后从 psql shell 运行以下命令

psql -h localhost -d databasename -U username -f "c://path_to_file.sql"

推荐阅读