postgresql - Import .sql file in pgadmin iii -


i want import sql file in postgresql. using pgadmin iii. create sql file in phpmyadmin , want import same file in pgadmin iii. doing following didn't work me. select schema of database in pgadmin iii , after try execute following query:

\i c:/users/umair/downloads/school_management_system(1).sql 

but generates error , error is:

error:  syntax error @ or near "\" line 1: \i c:/users/umair/downloads/school_management_system(1).sql         ^ ********** error **********  error: syntax error @ or near "\" sql state: 42601 character: 1 

please me out.

i think best way import sql file using psql tool this:

psql -u postgres -h localhost -d my_database -f "c:/users/umair/downloads/school_management_system(1).sql" 

Comments

Popular posts from this blog

python 2.7 - Chat Solution for Mobile App -

jquery - Detect current Section with javascript -