Error in executing SQL statement with PostgreSQL

Question

I create a new database 'sakila' with pgAdmin III in my local PostgreSQL database, then executed these sql statements:

sakila-schema.sql then sakila-data.sql

The first statement executed without error, however the second SQL did produced error when executed:

ERROR:  syntax error at or near "1"
LINE 112: 1 PENELOPE GUINESS 2006-02-15 09:34:33
          ^

********** Error **********

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

How to fix this error?

It seems pgAdmin does not support copy from stdin... Try to run the script using psql — user330315
– user330315, Commented Jul 26, 2012 at 16:30
I have succeeded in creating and populating the data here. I first had to do (from psql -U postgres postgres) create database sakila, and then (from the commandline) psql -U postgres sakila <sakila-schema.sql, followed by psql -U postgres sakila <sakila-data.sql — wildplasser
– wildplasser, Commented Jul 27, 2012 at 13:33

aleroot · Accepted Answer · 2012-07-26 18:14:37Z

18

You can't COPY FROM stdin with pgAdmin, you have to use psql tool, the problem is that pgAdmin is not a console application, there is no easily usable stdin so you can't COPY from Standard Input .

answered Jul 26, 2012 at 18:14

aleroot

73k32 gold badges182 silver badges220 bronze badges

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

3 Comments

quarks Over a year ago

I tried running "/i C:/postgresql/sakila-data.sql" (without the quotes), no errors but it didn't do a thing, since if I SELECT from the database tables its empty...

Craig Ringer Over a year ago

@xybrek \i not /i , and I'd say you didn't get any error because, except for backslash commands, psql doesn't respond to a command until a semicolon is found in the input.

aleroot Over a year ago

@xybrek try to import with psql -U postgres db_name < file.sql

Collectives™ on Stack Overflow

Error in executing SQL statement with PostgreSQL

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related