{"id":8432,"date":"2017-08-30T14:19:27","date_gmt":"2017-08-30T14:19:27","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=8432"},"modified":"2017-08-30T14:19:27","modified_gmt":"2017-08-30T14:19:27","slug":"batch-import-rtf-files-into-postgresql-bytea-blob-without-programming","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/pglobeditor\/batch-import-rtf-files-into-postgresql-bytea-blob-without-programming.html","title":{"rendered":"Batch import RTF files into PostgreSQL BYTEA (BLOB) without programming"},"content":{"rendered":"<p>Want to batch import RTF (Rich Text Format) documents into  <a href=\"https:\/\/www.postgresql.org\/\">PostgreSQL<\/a>  TEXT (CLOB) or BYTEA (BLOB) column?<\/p>\n<p>Using <a href=\"https:\/\/www.withdata.com\/pglobeditor\/\">PGLobEditor<\/a>, you can import bulk rtf files into  <a href=\"https:\/\/www.postgresql.org\/\">PostgreSQL<\/a>  TEXT (CLOB) or BYTEA (BLOB) easily and fast, just a few mouse clicks.<\/p>\n<p>Here you can <a href=\"https:\/\/www.withdata.com\/down\/PGLobEditor.exe\">download<\/a> and install <a href=\"https:\/\/www.withdata.com\/pglobeditor\/\">PGLobEditor<\/a>.<\/p>\n<h2>Batch import RTF documents to  <a href=\"https:\/\/www.postgresql.org\/\">PostgreSQL<\/a>  TEXT (CLOB) column<\/h2>\n<p> Click &#8220;Start New Task &#8211; Import LOB From Files&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/lobeditor\/task-list.png\" ALT=\"Batch import rtf files into PostgreSQL TEXT (CLOB)  - Task Window\" width=\"500\" height=\"373\" style=\"max-width:100%;height:auto;display:block;\"><\/p>\n<p>then show the wizard.<\/p>\n<p>1. Config.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/lobeditor\/batch-import-rtf-config.png\" ALT=\"Batch insert rtf files into PostgreSQL TEXT (CLOB) - config\" width=\"480\" height=\"570\" style=\"max-width:100%;height:auto;display:block;\"><\/p>\n<p>2. Import.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/lobeditor\/batch-import-rtf-import.png\" ALT=\"Batch save rtf files into PostgreSQL TEXT (CLOB)  - import\" width=\"480\" height=\"570\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>then you can see importing results<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/lobeditor\/batch-import-rtf-view.png\" ALT=\"Batch import rtf files into PostgreSQL TEXT (CLOB)  - view\" width=\"641\" height=\"598\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<hr style=\"clear: both;\" \/>\n<p><a href=\"http:\/\/www.withdata.com\/pglobeditor\/\">More about PGLobEditor &#8211; the tool to batch import RTF documents to PostgreSQL TEXT (CLOB) column<\/a><\/p>\n<div style=\"clear: both;\">\n<p>30-day free trial <a href=\"http:\/\/www.withdata.com\/down\/PGLobEditor.exe\"><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download PGLobEditor\" width=\"165\" height=\"50\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a>US$75.0 <a href=\"http:\/\/www.withdata.com\/pglobeditor\/purchase.html\"><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/btn_buynow_green.png\" alt=\"Buy PGLobEditor\" width=\"154\" height=\"45\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/> <\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Want to batch import RTF (Rich Text Format) documents into PostgreSQL TEXT (CLOB) or BYTEA (BLOB) column? Using PGLobEditor, you can import bulk rtf files into PostgreSQL TEXT (CLOB) or BYTEA (BLOB) easily and fast, just a few mouse clicks. Here you can download and install PGLobEditor. Batch import RTF documents to PostgreSQL TEXT (CLOB) [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[443],"tags":[97,100,1370,2106,2110],"class_list":["post-8432","post","type-post","status-publish","format-standard","hentry","category-pglobeditor","tag-blob","tag-clob","tag-postgresql","tag-rtf","tag-store-rtf-in-postgresql-blob-or-clob"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/8432","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=8432"}],"version-history":[{"count":1,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/8432\/revisions"}],"predecessor-version":[{"id":8433,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/8432\/revisions\/8433"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=8432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=8432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=8432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}