[SQL] Question on Escape-string

2008-12-31 Thread John Zhang
Dear all, I am using pl/pgsql to develop a function to implement some logic to load BLOB data, like .tif file, to postgres DB. The issue I am facing is the file name MUST be with double back-slash \\ in order for pgsql to process the string properly. However, when the string is Escaped in my funct

Re: [SQL] Object create date

2008-12-31 Thread Asko Oja
Hi About three years ago we started doing nightly schema dumps of all our databases and then updating these into CVS. That has proven to be pretty useful when there is need to determine when some change was done in database. regards, Asko On Tue, Dec 30, 2008 at 7:33 PM, Erik Jones wrote: > >