Re: [SQL] import sql script

no ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [SQL] escape single quote in INSERT command

Woops should have been masquerading ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] escape single quote in INSERT command

Hi Hunter, From my xbase++ program suite, sqlcontext class. * cValue := strtran(cValue,['],[\']) * Its called masquarading, simply replace the single quote with back_slash + single quote. Regards Mark Carew Brisbane

Re: [SQL] Hairy question - transpose columns

Hi Andres, For mine, I would read the data in using any langauage that I was familiar with and parse it into an array or some other form in the required format then create the "copy" statement for postgresql, connect and apply. Regards Mark ---(end of broadcast)

Re: [SQL] Problems with version 7.1, could they be fixed in 7.2?

Hi Ligia, Are you running VACUUM ANALYSE or is it VACUUM ANALYZE (can never remember, though reasonably sure that its the former). Regards Mark Carew Brisbane Australia ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

[SQL] 7.3 features and enhancements

Hi All, Can somebody direct me to a list of the above. Would be nice to know in advance of its release. Regards Mark ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org