1. Open the Data Source Explorer view (it's under the Connectivity category).

2. Right click on Databases and create a new Connection Profile.

3. Open an SQL script file.

4. Select the connection profile.

5. Run the script.

alomo wrote:

That's exactly what I did. I was running it on the localhost and it runs with many errors. Below is a history file after running the csns-create.sql script (see ERROR in lines 1040, 1059, 1071, 1086, and 1098 of the history file).

At the same time, this script successfully runs when in the pgAdmin.

 

csns-create.sql has a couple of stored procedures that use PL/pgSQL. I guess Eclipse doesn't recognize it.

alomo wrote:

cysun wrote:

alomo wrote:

That's exactly what I did. I was running it on the localhost and it runs with many errors. Below is a history file after running the csns-create.sql script (see ERROR in lines 1040, 1059, 1071, 1086, and 1098 of the history file).

At the same time, this script successfully runs when in the pgAdmin.

 

csns-create.sql has a couple of stored procedures that use PL/pgSQL. I guess Eclipse doesn't recognize it.

 

Although the errors occurred at the end of the script, only the first table (roles) was created.

The error message says something about $$, so my guess is that Eclipse tries to parse the whole thing starting at "create table users" as one statement. Whatever the problem is, it's an Eclipse issue and there's not much we can do about it. Just use pgAdmin or psql.