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