[GENERAL] win cmd line query tool

2006-02-21 Thread uuZZuuZZ (sent by Nabble.com)
I need a windows command line tool that will allow me to retrieve a row from a postgresql database (using odbc I would guess). I know osql won't work since it is geared to mssql. I tried dbisql from sybase but I don't need to install a CD to do this. I need something with a small foot print. Can I

Re: [GENERAL] win cmd line query tool

2006-02-21 Thread Martijn van Oosterhout
On Tue, Feb 21, 2006 at 06:39:13AM -0800, uuZZuuZZ (sent by Nabble.com) wrote: > > I need a windows command line tool that will allow me to retrieve a row from > a postgresql database (using odbc I would guess). I know osql won't work > since it is geared to mssql. I tried dbisql from sybase but I

Re: [GENERAL] win cmd line query tool

2006-02-21 Thread Tony Caduto
uuZZuuZZ (sent by Nabble.com) wrote: I need a windows command line tool that will allow me to retrieve a row from a postgresql database What's wrong with the one that comes with Postgresql? if you install the win32 server it's in the bin directory and called psql.exe, and you can install it s

Re: [GENERAL] win cmd line query tool

2006-02-21 Thread uuZZuuZZ (sent by Nabble.com)
niets is verkeerd met psql. What is it and where do I obtain it ? Do I have to install the entire postgresql package to make it work ? The target db is on a remote server from where psql will run. Dank u wel -- View this message in context: http://www.nabble.com/win-cmd-line-query-tool-t1162261.h

Re: [GENERAL] [PATCH] ipv6 support for getaddrinfo.c

2006-02-21 Thread Tom Lane
"R, Rajesh (STSD)" <[EMAIL PROTECTED]> writes: > Patch for getaddrinfo.c to recognize ipv6 addresses. Is this really interesting? Are there machines out there that have usable support for IPv6 and yet haven't got getaddrinfo? We've deliberately avoided trying to support ipv6 in our src/port/ sub

Re: [GENERAL] win cmd line query tool

2006-02-21 Thread Martijn van Oosterhout
On Tue, Feb 21, 2006 at 06:54:57AM -0800, uuZZuuZZ (sent by Nabble.com) wrote: > > niets is verkeerd met psql. > What is it and where do I obtain it ? Do I have to install the entire > postgresql package to make it work ? The target db is on a remote server > from where psql will run. You need to

[GENERAL] is there webadmin sw written in jsp/servlet

2006-02-21 Thread Ibrahim Tekin
hi,i need an admin tool like phpPgAdmin but written in jsp or servlets. does anybody know such project?

Re: [GENERAL] How to specify infinity for intervals ?

2006-02-21 Thread Karsten Hilbert
On Tue, Feb 21, 2006 at 12:24:09PM +0900, Michael Glaesemann wrote: > I don't know the details of your database schema, If you want to you can look it up here: http://salaam.homeunix.com/twiki/bin/view/Gnumed/DatabaseSchema Feel free to comment ! > but I think the > relationally prope

Re: [GENERAL] Question about COPY to/from

2006-02-21 Thread Scott Marlowe
On Mon, 2006-02-20 at 16:39, Emi Lu wrote: > Hello, > > We have millions of record and would like to insert into a table. I > remebered people mentioned that "COPY" is the most effecient way to > insert data, right? If not, which is it, pg_restore? Take a look inside a pg_dump output and guess

[GENERAL] TSearch2 from HEAD UTF8 German Compunds.

2006-02-21 Thread Thies C. Arntzen
hi, i'm using tsearch2 from HEAD with 8.1.3 (with some 8.1.x compile fixes) and want to use the UTF8 snowball stemmers. so far (haven't really hacked on it yet) with little success. i've seen some messages on the list lately but i failed to find a step-by-step guid how to use the utf8 ste

[GENERAL] Attn. PostgreSQL.org webmasters: Site Link not working

2006-02-21 Thread Sanjay Arora
Page: http://www.postgresql.org/docs/faqs.FAQ.htmlSection 2.3 GUI Tools Link http://techdocs.postgresql.org/guides/GUITools Proxy ErrorThe proxy server received an invalid response from an upstream server.The proxy server could not handle the request GET /guides/GUITools.Reason: Could not connect t

Re: [GENERAL] How to specify infinity for intervals ?

2006-02-21 Thread Michael Glaesemann
On Feb 22, 2006, at 1:51 , Karsten Hilbert wrote: I specifically wanted to avoid that by something like 'infinite'::interval in some way or other such that I could always do "... where now < date_of_birth + max_age ..." and not need an "... or max_age is null ..." in all the

Re: [GENERAL] How to specify infinity for intervals ?

2006-02-21 Thread Bruno Wolff III
On Mon, Feb 20, 2006 at 19:24:05 +0100, Karsten Hilbert <[EMAIL PROTECTED]> wrote: > > I *could*, of course, use something like '999 years' as a > special value to indicate "no upper limit" figuring that no > one is going to live that long in the foreseeable future. I would think that specifyin

[GENERAL] Postgresql Replication

2006-02-21 Thread Nareen S
Current Setup I am having a Mailserver running on Postfix.For the same I had configured  a High Availability Solution using Heartbeat and DRBD for replication.The setup is like Primary/Secondary Node Servers and all mails are replicated to secondary using DRBD.If primary server fails secondary wil

Re: [GENERAL] TSearch2 from HEAD UTF8 German Compunds.

2006-02-21 Thread Teodor Sigaev
Contact with Alexander Presber about dictionaries, he now work on it. UTF8 will work only in CVS HEAD (8.2 release in the future) Thies C. Arntzen wrote: hi, i'm using tsearch2 from HEAD with 8.1.3 (with some 8.1.x compile fixes) and want to use the UTF8 snowball stemmers. so far (haven't re