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?

Answer 1

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 .