AFAIR (Postgres 6.5 - 7.1.3):
cd /usr/src/postgresql-X.X.X/src/interfaces/libpq++/examples
[postgres@xxx examples]$ /usr/local/pgsql/bin/psql
Password:
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
postgres=# \i testlibpq2.sql
CREATE
CREATE
psql:testlibpq2.sql:5: ERROR: parser: parse error at or near ""
psql:testlibpq2.sql:5: ERROR: parser: parse error at or near "]"
postgres=# \q
[postgres@komuna examples]$ cat testlibpq2.sql
CREATE TABLE TBL1 (i int4);
CREATE TABLE TBL2 (i int4);
CREATE RULE r1 AS ON INSERT TO TBL1 DO [INSERT INTO TBL2 values (new.i);
NOTIFY TBL2];
[postgres@komuna examples]$
What is wrong?
