So I'm making the transition finnaly and leaving the old microsoft tools behind to embrace the 'hardcore'. Postgres here I come.
I have a website with all of its data in an access (mdb) file (its a news update site similar in functionality to slashdot and the like). I generated a script to insert all of the news posts into the new postgres news table i built. here's the problem.
i have a lot of apostrophes in the text. Do i do the usual double apostrophe ('') like in access, or something else? are there any other 'special' characters i need to worry about?
also, i have a link to a picture and the text of the link contains '\media\gorelogo.jpg'. well, its giving me problems with the '\g' part of it, i guess cause it thinks it the execute command.
could someone answer this or point me to a page with an in depth description of all the wacky stuff that one is supposed to do in an insert statement?
thanks in advance.
I have a website with all of its data in an access (mdb) file (its a news update site similar in functionality to slashdot and the like). I generated a script to insert all of the news posts into the new postgres news table i built. here's the problem.
i have a lot of apostrophes in the text. Do i do the usual double apostrophe ('') like in access, or something else? are there any other 'special' characters i need to worry about?
also, i have a link to a picture and the text of the link contains '\media\gorelogo.jpg'. well, its giving me problems with the '\g' part of it, i guess cause it thinks it the execute command.
could someone answer this or point me to a page with an in depth description of all the wacky stuff that one is supposed to do in an insert statement?
thanks in advance.