Reputation: 35346
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?
Upvotes: 12
Views: 9505