Error in executing SQL statement with PostgreSQL
postgresql, sql
Solution
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 .
Problem
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?