Search Postgresql Archives

Re: Help : Microsoft SQL Server equivalents in PostGreSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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"
> 
> 




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux