Re: Help : Microsoft SQL Server equivalents in PostGreSQL

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(dot)Faria(at)Sun(dot)COM]
> Sent: den 19 januari 2007 14:02
> To: pgsql-general(at)postgresql(dot)org
> 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(dot)Faria(at)sun(dot)com
> <mailto:Benedict(dot)Faria(at)sun(dot)com>> 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(dot)Faria(at)sun(dot)com
> <mailto:Benedict(dot)Faria(at)sun(dot)com>
> --------------------------------------------------------------------
> 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"
>
>