How do you delete a sound library from a Postgres database

I'm trying to work out how I can remove a large sound library from my networked database as the audio files have moved to a new location. I can rescan the files at the new location, however I don't want thousands of empty entries in the library where the old ones used to be.

From scouring the forums I understand I can use pgAdmin to achieve this, however I have no idea how to use it properly and I don't want to accidentally corrupt my projects. I am able to access the database using the host address and login details but after that I have no idea what to do

Not sure if it makes any difference but the database is on a Linux machine

Dropping tables in PgAdmin is a sure way to invalidate the database. I'd hire someone with experience in SQL, Before anyone does anything make sure you backup the database first.