[GENERAL] Problem - PostgreSQL Truncating Column Names to 63 Characters

2005-05-13 Thread Darren Houston
Hello everyone, I guess I'm not typing in the right search string for my question because I can't find any answer on the Internet. So I'm coming to all of you for help. I'm performing a cross-tab type query in PostgreSQL where the returned data in rows become my column names. The problem I'm faci

Re: [GENERAL] Problem - PostgreSQL Truncating Column Names to 63 Characters

2005-05-13 Thread Darren Houston
Hello Tom and Alvaro, The solution you guys provided is exactly the answer I needed. Thank you for your help and saving me time, Darren H. On 5/13/05, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > On Fri, May 13, 2005 at 10:07:43AM -0600, Darren Houston wrote: > > Hello everyone,

Re: [GENERAL] Happiness is a cross database link...

2005-01-05 Thread Darren Houston
Hello Alex, DBLink is located in the PostgreSQL source under $POSTGRES_SOURCE/contrib/dblink Just do a make and make install (assuming you installed PostgreSQL from source). The docs are also located in the same directory. You have to execute dblink.sql against your database to implement the func