I have dropped my table but the sequence name that was created for the serial primary key still remains. How do I delete this as well?
Probably a stupid question, but have you tried looking this up in the PostgreSQL manual?
Actually, you don't need the manual. Look up the drop command on the psql command line interface:
\h lists all sql commands \h drop sequence shows the syntax of the drop sequence backslash command.
