Ygthkb

What happened to Hermione’s clothing and other possessions after she wiped her parents’ memories of her?

Is it possible to detect 100% of SQLi with a simple regex?

Are there historical references that show that "diatonic" is a version of 'di-tonic' meaning 'two tonics'?

How do I add a strong "onion flavor" to the biryani (in restaurant style)?

Process substitution inside a subshell to set a variable

Is "accuse people to be racist" grammatical?

Is it really OK to use "because of"?

How can I keep my gold safe from other PCs?

Is it possible to set values for a list of variables using a for loop?

Did ancient Germans take pride in leaving the land untouched?

Disk space full during insert, what happens?

Do the speed limit reductions due to pollution also apply to electric cars in France?

Is layered encryption more secure than long passwords?

Lubuntu 18.10 File Manager: How to view directory tree structure?

What could cause an entire planet of humans to become aphasic?

Why did Ylvis use "go" instead of "say" in phrases like "Dog goes 'woof'"?

show notifications of new e-mails without displaying the content

How can I put a period right after the algorithm's number in the algorithm's title?

Taking an academic pseudonym?

Isn't a semicolon (';') needed after a function declaration in C++?

In a post-apocalypse world, with no power and few survivors, would Satnav still work?

Players preemptively rolling, even though their rolls are useless or are checking the wrong skills

Crack the bank account's password!

Sing Baby Shark

How to insert very big XML data file to PostgreSQL

How to insert (file) data into a PostgreSQL bytea column?How to insert (file) data into a PostgreSQL bytea column?SQL to read XML from file into PostgreSQL databaseLoading XML documents to Oracle 11g DB with control fileRETURN NEXT in Postgres FunctionHow to Insert records from remote database to local database using dblink in postgresql 9.3mysql to postgresql, migrate files directly ( longblob > pg_largeobject )Selecting from a table contains a XML columnHow can I import data from a NetCDF file into SQL Server?Use non-printable characters in SQL Server BCP xml format file as TERMINATORPostgresql - Large object exists in pg_largeobject table but cannot open with lo_open?

0

I'm using PostgreSQL 9.5 and trying to import XML data file to database.
To load the XML I use this function from here

CREATE OR REPLACE FUNCTION bytea_import(p_path text, p_result out bytea) as

$$

DECLARE 

  l_oid oid;

BEGIN 

  SELECT lo_import(p_path) INTO l_oid;

  SELECT lo_get(l_oid) INTO p_result;

  PERFORM lo_unlink(l_oid);

END;

$$

LANGUAGE plpgsql;

I successfully load data from a small XML file, but when I try a 4GB XML file,
it returns error:

SQL Error [54000]: ERROR: large object read request is too large  

Where: SQL statement "SELECT lo_get(l_oid)" PL/pgSQL function

bytea_import(text) line 6 at SQL statement.

It seems lo_get cannot read/extract very large data.
It's said that since version 9.4, PostgreSQL can handle up to 4TB, so how can I import very large XML data file to PostgreSQL 9.5?

Thanks in advance

postgresql import xml plpgsql blob

share

asked 2 mins ago

BonZBonZ

1

New contributor

BonZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I'm using PostgreSQL 9.5 and trying to import XML data file to database.
To load the XML I use this function from here

CREATE OR REPLACE FUNCTION bytea_import(p_path text, p_result out bytea) as

$$

DECLARE 

  l_oid oid;

BEGIN 

  SELECT lo_import(p_path) INTO l_oid;

  SELECT lo_get(l_oid) INTO p_result;

  PERFORM lo_unlink(l_oid);

END;

$$

LANGUAGE plpgsql;

I successfully load data from a small XML file, but when I try a 4GB XML file,
it returns error:

SQL Error [54000]: ERROR: large object read request is too large  

Where: SQL statement "SELECT lo_get(l_oid)" PL/pgSQL function

bytea_import(text) line 6 at SQL statement.

It seems lo_get cannot read/extract very large data.
It's said that since version 9.4, PostgreSQL can handle up to 4TB, so how can I import very large XML data file to PostgreSQL 9.5?

Thanks in advance

postgresql import xml plpgsql blob

share

asked 2 mins ago

BonZBonZ

1

New contributor

BonZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I'm using PostgreSQL 9.5 and trying to import XML data file to database.
To load the XML I use this function from here

CREATE OR REPLACE FUNCTION bytea_import(p_path text, p_result out bytea) as

$$

DECLARE 

  l_oid oid;

BEGIN 

  SELECT lo_import(p_path) INTO l_oid;

  SELECT lo_get(l_oid) INTO p_result;

  PERFORM lo_unlink(l_oid);

END;

$$

LANGUAGE plpgsql;

I successfully load data from a small XML file, but when I try a 4GB XML file,
it returns error:

SQL Error [54000]: ERROR: large object read request is too large  

Where: SQL statement "SELECT lo_get(l_oid)" PL/pgSQL function

bytea_import(text) line 6 at SQL statement.

It seems lo_get cannot read/extract very large data.
It's said that since version 9.4, PostgreSQL can handle up to 4TB, so how can I import very large XML data file to PostgreSQL 9.5?

Thanks in advance

postgresql import xml plpgsql blob

share

asked 2 mins ago

BonZBonZ

1

New contributor

BonZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

CREATE OR REPLACE FUNCTION bytea_import(p_path text, p_result out bytea) as

$$

DECLARE 

  l_oid oid;

BEGIN 

  SELECT lo_import(p_path) INTO l_oid;

  SELECT lo_get(l_oid) INTO p_result;

  PERFORM lo_unlink(l_oid);

END;

$$

LANGUAGE plpgsql;

SQL Error [54000]: ERROR: large object read request is too large  

Where: SQL statement "SELECT lo_get(l_oid)" PL/pgSQL function

bytea_import(text) line 6 at SQL statement.

share

asked 2 mins ago

BonZBonZ

1

New contributor

BonZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 2 mins ago

BonZBonZ

1

New contributor

BonZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

BonZBonZ

1

New contributor

BonZ is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

BonZBonZ

1