New user question -- alternate programmer interfaces?

To make a long story short, I've recently been learning PostgreSQL
(and SQL in general) in a sort of trial-by-fire fashion.  I copied
the .pdf of Bruce Momjian's book onto my iBook and hacked out some
code while I was traveling on business for a couple of weeks,
largely without benefit of connectivity to a host where I could
test things.  Now I have about 1000 lines of doubtless very buggy
code --- and I don't see any way to feed it to PostgreSQL for
parsing other than to copy and paste into psql.  (Aside from the
obvious frustrations, psql seems to lock up whenever I paste more
than about 15 lines of code into it.)

Obviously I'm missing something.  I assume there's a emacs mode for
interacting with PostgreSQL from within emacs?  Or at least some
way to feed PostgreSQL a text file of code and have it spit back
debugging info?

Thanks in advance for any pointers!