Received: from rgate3.ricochet.net (rgate3.ricochet.net [204.179.143.7]) by hub.org (8.9.2/8.9.1) with ESMTP id VAA74238 for ; Wed, 17 Feb 1999 21:42:59 -0500 (EST) (envelope-from adam@bamf.frotz.net) Received: from socket.house (mg131-098.ricochet.net [204.179.131.98]) by rgate3.ricochet.net (8.8.8/8.8.8) with ESMTP id UAA20964 for ; Wed, 17 Feb 1999 20:42:56 -0600 (CST) Received: from adam by socket.house with local (Exim 1.92 #1 (Debian)) id 10DJbu-0006VO-00; Wed, 17 Feb 1999 18:54:42 -0800 Message-ID: <19990217185442.B24956@ricochet.net> Date: Wed, 17 Feb 1999 18:54:42 -0800 From: Adam Haberlach To: pgsql-interfaces@postgresql.org Subject: List of characters to escape for safe psql imports Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.91.2 Sender: Adam Haberlach I am looking at using a Frontier script to export the data from a FileMaker Pro database (as you all may have heard earlier). Is there an official list of chracters that should be escaped from the input stream and how they should be escaped? I know that ' and \ need to be escaped with \'s, but I am wondering if there are any other gotchas out there.