import .sql file in postgres using \i command from java

Question

I am trying to import database from .sql file in postgres using "\i E:/dump.sql" command , its working fine from postgres command prompt but when i try the same from java it raise an error at "\" , my code is

connection = DriverManager.getConnection( "jdbc:postgresql://localhost:5432/database","postgres", "passwd");
PreparedStatement ps3 = connection.prepareStatement("\\i E:/dump.sql");
boolean res3= ps3.execute();
System.out.println("imported succesfully .."+res3);

Anders R. Bystrup · Accepted Answer · 2013-07-04 12:51:36Z

3

With the JDBC driver/interface you can only talk SQL, what you're trying is to issue PostgreSQL commandline tool (psql) specific commands. That won't work.

If you insist on doing this, you could use the Runtime.getRuntime().exec(...) approach, something like

Runtime.getRuntime().exec( "psql -f dump.sql" );

Cheers,

edited Jul 4, 2013 at 12:51

answered Jul 4, 2013 at 11:47

Anders R. Bystrup

16.1k11 gold badges65 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Mohammed Anwar Over a year ago

thanks for the answer , how i can do the same with Runtime.getRuntime().exec() ..can you please elaborate it.

Anders R. Bystrup Over a year ago

Here on Stackoverflow you are expected to show some effort yourself. There are tons of resources on this matter here and elsewhere.

Mohammed Anwar Over a year ago

it doesn't work dude , becoz with "psql -f dump.sql" it will prompt you for password . how i would provide that ? .. ok . i will be managing that using ProcessBuilder and its environment() method . but still its raising error path specified not found . just stucked!

Anders R. Bystrup Over a year ago

Look at this post or setup trust in pg_hba.conf

user80168 · Accepted Answer · 2013-07-04 12:27:28Z

1

Long story short - you can't. \i is not PostgreSQL command (as in: PostgreSQL database engine). It's command of psql - which is command line tool for interacting with database.

If you're connecting to database via JDBC you're not using psql, so you can't use its commands (\i, \o and alike).

answered Jul 4, 2013 at 12:27

user80168

1 Comment

user80168 Over a year ago

sure, open the file, read ot, oarse into separate queries, and send them to pg. or use psql, like Anders suggested.

Collectives™ on Stack Overflow

import .sql file in postgres using \i command from java

2 Answers 2

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related