I have come up w/ this solution to add A records into the db...
#!/bin/sh
mysql -Ns -uadmin -p`cat /etc/psa/.psa.shadow` -D psa -e"INSERT INTO `psa`.`dns_recs` (`dns_zone_id`,`type`,`displayHost`,`host`,`displayVal`,`val`) VALUES((SELECT `id` FROM `dns_zone` WHERE `name` LIKE '$1'),'A','$2.$1','$2.$1','$3','$3');"
exit 0
Which is run like...
./mydns.sh example.com subname 127.0.0.1
But yes your right...
/usr/local/psa/bin/dns -a example.com -a subname -ip 127.0.0.1
... is a lot easier.