vickr1z |
11-08-2004 01:54 AM |
postgres COPY function needed help
im having this error on my script:
psqlolmap.sql:18: invalid command \.
psqlolmap.sql:36: invalid command \.
polmap.sql
Code:
\c polmap
BEGIN;
SET search_path = public, pg_catalog;
--
-- Data for TOC entry 315 (OID 761231)
-- Name: provinces; Type: TABLE DATA; Schema: public; Owner: dbadmin
--
COPY provinces (province_name, province_code, db_user, "timestamp") FROM stdin;
APAYAO 988100000 dbadmin 2004-01-27 06:48:19.458466
MOUNTAIN PROVINCE 984400000 dbadmin 2004-01-27 06:48:19.458466
KALINGA 983200000 dbadmin 2004-01-27 06:48:19.458466
IFUGAO 982700000 dbadmin 2004-01-27 06:48:19.458466
\.
--
-- Data for TOC entry 316 (OID 761238)
-- Name: municipalities; Type: TABLE DATA; Schema: public; Owner: dbadmin
--
COPY municipalities (municipality_name, municipality_code, db_user, "timestamp") FROM stdin;
SAN MIGUEL 993907000 dbadmin 2004-01-27 06:48:19.464152
MALATE 993910000 dbadmin 2004-01-27 06:48:19.464152
CITY OF LAS PIÑAS 997601000 dbadmin 2004-01-27 06:48:19.464152
CITY OF PARAÑAQUE 997604000 dbadmin 2004-01-27 06:48:19.464152
PASAY CITY 997605000 dbadmin 2004-01-27 06:48:19.464152
SAN NICOLAS 993904000 dbadmin 2004-01-27 06:48:19.464152
NAVOTAS 997503000 dbadmin 2004-01-27 06:48:19.464152
TONDO 993901000 dbadmin 2004-01-27 06:48:19.464152
\.
what does the errors mean: do i have to edit my script?? i just got this created from a database dump (pg_dump -h 192.12.0.100 polmapdb > polmap.sql)
how can i fix my script so it would run correctly?? any idea will appreciate very much..
|