PDF Text Extraction to SQL

I have a batch of PDFs that contain only plain-text content. Every word from every page needs to land neatly in a single SQL table—no images, no form fields, just raw text.

Here is what the finished job looks like to me:

• A script (Python, Java, or similar) that reads each PDF, pulls out the complete text, and writes it into a table such as `pdf_text` with columns like `id`, `file_name`, `page_number`, and `text_block`.
• A SQL file that creates this table and lets me recreate it easily on MySQL or PostgreSQL.
• Clear instructions so I can rerun the process whenever new PDFs arrive.

Accuracy is critical: the stored text must perfectly match the source PDF, page by page. If you prefer libraries such as PyPDF2, PDFMiner, Tika, or pdftotext, feel free—as long as the output is reliable and the setup steps are documented.

Once the import script runs without errors and I can query every PDF line from the database, the project is complete.