I think you can use the binary string functions (http://www.postgresql.org/docs/8.2/interactive/functions-binarystring.html) to achieve the same as ReadText and UpdateText. /Mikael > -----Original Message----- > From: Benedict Faria [mailto:Benedict.Faria@xxxxxxx] > Sent: den 19 januari 2007 14:02 > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Help : Microsoft SQL Server equivalents in PostGreSQL > > Hello, > my customer, ntl:Telewest is using an open source 'file upload progress > bar' called NeatUpload to help users to upload video files to a MS SQL > database. They want to replace the MS SQL database with > Solaris/PostgreSQL and ZFS. > > There is an extension to NeatUpload that enables this to work with MS > SQL Server. I emailed the author of this extension to ask how easy it > would be to replace MS SQL Server with PostgreSQL. His reply (below) > suggests that I need to use a postgreSQL equivalent for "Updatetext" and > "ReadText" in MS SQL Server. Any pointers on what the PostgreSQL > equivalent is? > > Many thanks. > > ------------------------------- forwarded email > ------------------------------------------------ > Hi Benedict, > Re: NeatUpload SqlServerInputFile Extension with PostGres in Solaris 10. > > In my implementation of SqlServerInputFile I use the commands > "updatetext" and "readtext", which are as far as I know Microsoft SQL > Server specific. If there is an equivalent in postgresql you could use > that instead. > > If there is no equivalent commands, it is possible to use "standard" SQL > to do the same task (i.e. writing chunks of a file to a database) but > there is no such code in my code at this point. > > If you indend to rewrite the code so that it works, look at the > SqlServerBlobStream class, and the functions GenerateReadCommand and > GenerateWriteCommand. They aer the ones responsible, and has to be > rewritten using neutral SQL language. To make the file upload work you > really only need to fix "GenerateWriteCommand". > > If you manage to make it work I'd love to take a look at it! I've never > used postGreSQL, although I've read quite a lot about it. I think I even > have some 6 months old installation files here somewhere I never had > time to use... ;) > Any further questions, please ask. > Best regards / med vänlig hälsning > Joakim Wennergren, Hitone Nordic AB > Tel: +46 8 556 18 754, Fax: +46 8 556 18 755, Mobile: +46 70 191 42 59 > > > On 1/17/07, *Benedict Faria* <Benedict.Faria@xxxxxxx > <mailto:Benedict.Faria@xxxxxxx>> wrote: > > Joakim, > I have a requirement to upload content to a PostGres database on > Solaris > 10 instead of a Microsoft SQL database. PostGres is an open source SQL > database. See http://www.postgresql.org/ <http://www.postgresql.org/> > > From the documentation at > http://www.brettle.com/NeatUpload- > 1.2/docs/Manual.html#SqlServerInputFile > I don't envisage any issues with doing this, but I though I'd email > you > to confirm. Could you help? > Many thanks. > Benedict. > > --------------------------------------------------------------------- > Benedict Faria > Engagement Architect, Client Solutions - Comms & Media > --------------------------------------------------------------------- > Sun Microsystems Computers, Tel : +44 (0)207-256-3200 (Switchboard) > Regis House, : +44 (0)207-469-9725 (Direct line) > 55 King William Street, Fax : +44 (0)207-469-9910 > London, Mob : +44 (0)7711-053-822 > EC4R 9AD. Email: Benedict.Faria@xxxxxxx > <mailto:Benedict.Faria@xxxxxxx> > -------------------------------------------------------------------- > Network with peers, keep pace with technology : > Technical community: http://www.sun.com/boardroom > Executive community: http://www.sun.com/innercircle > "The box said 'Windows Server 2003 or better', so I installed > Solaris10" > >
