Page 1 of 1

How do you delete a sound library from a Postgres database

PostPosted: Thu May 09, 2024 12:07 am
by CraftyClown
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

Re: How do you delete a sound library from a Postgres databa

PostPosted: Thu May 09, 2024 4:10 am
by Igor Riđanović
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.