Import a XML file to postgres, why $body$ error?

Question

CREATE OR REPLACE FUNCTION f_sync_from_xml()
  RETURNS boolean AS
$BODY$
DECLARE
    myxml    xml;
    datafile text := 'path/to/my_file.xml';
BEGIN

myxml := pg_read_file(datafile, 0, 100000000);

This function returns error

ERROR: unterminated dollar-quoted string at or near "$BODY$

. How do I solve it?

It is the whole code... error is string delimited from dollars not terminated — James
– James, Commented Nov 21, 2017 at 9:57

Vao Tsun · Accepted Answer · 2017-11-21 10:01:10Z

2

the definition is not completed, yo uneed to terminate it, eg:

CREATE OR REPLACE FUNCTION f_sync_from_xml()
  RETURNS boolean AS
$BODY$
DECLARE
    myxml    xml;
    datafile text := 'path/to/my_file.xml';
BEGIN

myxml := pg_read_file(datafile, 0, 100000000); 

END;
$BODY$ language plpgsql;

here $BODY$ is a safe quote - function definition remains inside quotes

answered Nov 21, 2017 at 10:01

Vao Tsun

52.5k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

James Over a year ago

CREATE TEMP TABLE tmp AS SELECT (xpath('//some_id/text()', x))[1]::text AS id FROM unnest(xpath('/xml/path/to/datum', myxml)) x;

Vao Tsun Over a year ago

please don't debug in comments - if you meet problem you can't solve after reading docs and googling - post a new question

Collectives™ on Stack Overflow

Import a XML file to postgres, why $body$ error?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related