I've been using this for pgsql:

find . -type f -name "*.sql" -exec etags --regex="/create[ 	]+table[ 	]+([^ 	]+)/
/" --regex="/create[ 	]+function[ 	]+([^ 	]+)/
/"

You could also extend this to find indices, views and just about anything else you would like to find quickly.