在pgadmin iii中导入.sql文件 [英] Import .sql file in pgadmin iii

问题描述

我想在PostgreSQL中导入一个sql文件.我正在使用pgadmin iii.我在phpmyadmin中创建了一个sql文件，现在我想在pgadmin iii中导入相同的文件. 我正在关注，但对我没有用. 我在pgadmin iii中选择数据库的架构，然后尝试执行以下查询:

I want to import a sql file in PostgreSQL. I am using pgadmin iii. I create an sql file in phpmyadmin and now i want to import same file in pgadmin iii. I am doing following but it didn't work for me. I select schema of the database in pgadmin iii and after that I try to execute following query:

\i C:/Users/umair/Downloads/school_management_system(1).sql

但是它生成一个错误，错误是:

but it generates an error and the error is:

ERROR:  syntax error at or near "\"
LINE 1: \i C:/Users/umair/Downloads/school_management_system(1).sql
        ^
********** Error **********

ERROR: syntax error at or near "\"
SQL state: 42601
Character: 1

请帮帮我.

推荐答案

我认为导入sql文件的最佳方法是使用psql工具，如下所示:

I think that the best way to import an sql file is using the psql tool like this:

psql -U postgres -h localhost -d my_database -f "C:/Users/umair/Downloads/school_management_system(1).sql"

这篇关于在pgadmin iii中导入.sql文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！