Re: [GENERAL] Help : Microsoft SQL Server equivalents in PostGreSQL

2007-01-22 Thread dean
Benedict Faria wrote: > I need to use a postgreSQL equivalent for "Updatetext" and > "ReadText" in MS SQL Server. Any pointers on what the PostgreSQL > equivalent is? Hi Benedict, I don't see an exact equivalent to MS SQL Server's UpdateText (and ReadText) commands in pgsql or any other PostgreSQ

Re: [GENERAL] Help : Microsoft SQL Server equivalents in

2007-01-20 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/20/07 10:52, Bruce Momjian wrote: > Ron Johnson wrote: >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA1 >> >> On 01/19/07 18:21, Bruce Momjian wrote: >>> Sorry, I know of no way to get a status bar that shows how far the an >>> INSERT or COPY

Re: [GENERAL] Help : Microsoft SQL Server equivalents in

2007-01-20 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Ron Johnson wrote: >> How hard *would* it be to patch the \copy code to print out a "#" >> every N number of input records? > Yea, probably, but considering they probably want a graphic progress > bar, the big question is what API would you use to allow

Re: [GENERAL] Help : Microsoft SQL Server equivalents in

2007-01-20 Thread Bruce Momjian
Ron Johnson wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 01/19/07 18:21, 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.

Re: [GENERAL] Help : Microsoft SQL Server equivalents in

2007-01-20 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/19/07 18:21, 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. How hard *would* it be to patch

Re: [GENERAL] Help : Microsoft SQL Server equivalents in

2007-01-20 Thread Tino Wildenhain
Bruce Momjian schrieb: 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. Well but thats aparently not the case here anyway. Fileupload is something different from looking h

Re: [GENERAL] Help : Microsoft SQL Server equivalents in PostGreSQL

2007-01-20 Thread Mikael Carneholm
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:[EMAIL PROTECTED] > Sent: den 19 januari 2007 14:02 >

Re: [GENERAL] Help : Microsoft SQL Server equivalents in

2007-01-19 Thread Matthew T. O'Connor
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

Re: [GENERAL] Help : Microsoft SQL Server equivalents in

2007-01-19 Thread Bruce Momjian
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, n