Punctuation problems.

Hello list,

I'm using PyGreSQL to access my database to store information gathered from 
HTML forms (using CGI). However I've run into a problem with some of the data 
retrived.

For example say a user of my HTML form inputs their  name "Eick O'Shae".
Now when I try to store that I get problems due the ' I think. Is there a way 
I can store and ' in the DB? Also are there other symbols should be aware of, 
and can I store them also? This email probably isn't making much sense as I'm 
very tired and have been looking at this screen for hours, but any help would 
great.

Thanks
-Al