Re: [SQL] designer tool connect to PostgreSQL

2004-03-07 Thread Silke Trissl
[EMAIL PROTECTED] schrieb: Hi, i use postgresql as my database. does anyone know the designer tool that can connect to postgeSQL ??? meaning to say the tools can handle design task like create table , etc . appreciate if u can give the specific URL. thanks in advance. Try this one: http://www

Re: [SQL] Read bytea column from table and convert into base64.....

2004-03-07 Thread Achilleus Mantzios
O kyrios beyaNet Consultancy egrapse stis Mar 5, 2004 : > Hi, > I have a bytea column which I want to convert into base64. At the > moment I am reading the bytea colum into my java app as a byte[]. I am > then calling another static method to convert the byte[] into base64. I > want postgreSQl

Re: [SQL] designer tool connect to PostgreSQL

2004-03-07 Thread Yasir Malik
Well, there's phpPgAdmin. It's available at http://phppgadmin.sourceforge.net/ Yasir On Mon, 8 Mar 2004 [EMAIL PROTECTED] wrote: > Date: Mon, 8 Mar 2004 10:13:53 +0800 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: [SQL] designer tool connect to PostgreSQL > > Hi, > > i use postgre

[SQL] designer tool connect to PostgreSQL

2004-03-07 Thread azwa
Hi, i use postgresql as my database. does anyone know the designer tool that can connect to postgeSQL ??? meaning to say the tools can handle design task like create table , etc . appreciate if u can give the specific URL. thanks in advance.

Re: [SQL] VIEW on lookup table

2004-03-07 Thread JJ Gabor
> Yes. If you create a table with all of the values, 1 to 100,000+, and then > join that with lookup_data, using a "left outer join", and then use a > case statement for the value -- when NULL, 'Unknown', then it should > work. This would still require constructing a large table, which is wha