Zend certified PHP/Magento developer

In which table are images stored in db?

For each product I want to know the local image path. I want to make a script and make my own images from an existing installation in my computer.

Is there a way to do it?

For my local development environment I cloned a remote db and I anonymized it. But I also want to replace the images with dummy ones as well. Is there a way to do this? An approach of mine is to:


$sql = "SELECT images from img_table";

$pdoConn = new PDO();

$stmt = $pdo->query($sql);
while ($row = $stmt->fetch()) {
    // create an img here with gd
}

DO you know how I can do this?