Re: Help : Microsoft SQL Server equivalents in
От | Matthew T. O'Connor |
---|---|
Тема | Re: Help : Microsoft SQL Server equivalents in |
Дата | |
Msg-id | 45B1A90A.2020601@zeut.net обсуждение исходный текст |
Ответ на | Re: Help : Microsoft SQL Server equivalents in (Bruce Momjian <bruce@momjian.us>) |
Список | pgsql-general |
I don't think he's looking for progress information, I think he is looking to be able to insert in chunks, which I don't know much about, but I think the some of the binary types (bytea or blob) support this. Anyone? Bruce Momjian wrote: > Sorry, I know of no way to get a status bar that shows how far the an > INSERT or COPY has progressed. People have asked for it, but no one has > any idea how to implement it. > > --------------------------------------------------------------------------- > > Benedict Faria wrote: >> 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" >> >> >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 5: don't forget to increase your free space map settings >
В списке pgsql-general по дате отправления:
Следующее
От: "Shoaib Mir"Дата:
Сообщение: Re: Installing Postegres side-by-side with M$ SQL server