{"repo":"Florents-Tselai/pgpdf","free":true,"listed":false,"github":"https://github.com/Florents-Tselai/pgpdf","clone":"git clone https://github.com/Florents-Tselai/pgpdf.git","description":"pdf type for Postgres","language":"C","stars":226,"topics":["documents","pdf","postgresql"],"license":"GPL-2.0","category":"databases-storage","readme_excerpt":"pgPDF: pdf type for Postgres This extension for PostgreSQL provides a pdf data type and assorted functions. You can create a pdf type, by casting either a text filepath or bytea column. If you don’t have the PDF file in your filesystem, but have already stored its content in a bytea column, you can just cast it to pdf . Why? : This allows you to work with PDFs in an ACID-compliant way. The usual alternative relies on external scripts or services which can easily make your data ingestion pipeline brittle and leave your raw data out-of-sync. The actual PDF parsing is done by poppler. Also check blog: - Full Text Search on PDFs With Postgres - pgpdf: pdf type for Postgres Usage Download some PDFs. Create a table with a pdf column: Parsing and validation should happen automatically. The files will be read from the disk only once! [!NOTE] The filepath should be accessible by the postgres process / user! That's different than the user running psql. If you don't understand what this means, as your DBA! Reading from URLs You can combine pgpdf with pgsql-http to quickly grab remote PDFs into Postgres, by fetching the remote content as bytea and then treat it as a PDF. String Functions and Operators Standard Postgres String Functions and Operators should work as usual: Full-Text Search (FTS) You can also perform full-text search (FTS), since you can work on a pdf file like normal text. Document similarity with pg trgm You can use pg trgm to get the similarity between two documents: Met","default_branch":null,"files":null,"tree":[],"storefront":"/r/Florents-Tselai","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Florents-Tselai/pgpdf/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}