Carol Walter <walterc@indiana.edu> writes:
> ... Why does this come back
> with all the tables intact when I drop it and recreate a database
> with the same name?
Most likely, you accidentally created all that stuff in template1,
and CREATE DATABASE is just copying it from there. Clean out template1.
regards, tom lane