Re: [GENERAL] Extracting Index Creation Script

Hello, I answered my own question. :) I continued looking last night after I posted this and found a really easy way to get this info... select * from pg_indexes where tablename like 'YOURTABLENAME' This will give you the DDL to create your indexes. Regards, Paul Paul Silveira wrote

[GENERAL] Extracting Index Creation Script

Hello, Does anyone have any good code to extract the metadata needed to create indexes on a specific table? The Client Tools (like pgadmin-III) presents that code so I'm sure it's extractable but could not find it in my trace that I ran while operating pgadmin... Thanks in advance, Paul --

[GENERAL] which schema to install contrib modules

Hello, I was wonding what the community's opinion was on which schema the contrib modules should be installed into. I intend on using DBLink, tsearch2, and xml2 and have initially installed them in the public schema. That will work but it really clutters that schema and I was also intending on

Re: [GENERAL] xml2 install problem

Thanks Devrim, I'll try the up2date command and post back my successs on this list... Have a happy holiday... -Paul Devrim GUNDUZ-3 wrote: Hi Paul, On Wed, 2006-12-20 at 14:07 -0800, Paul Silveira wrote: ok. tried to install the correct libs and then do it but still same errors

[GENERAL] psql SCHEMA switch

I was trying to run a psql script today against a database today. This script was schema agnostic. (There were table creations and function creations but none of them contained the specific schema to create them in...) I wanted to connect to a DB and then insert that new DDL into a specific

Re: [GENERAL] xml2 install problem

Thanks Devrim and Peter... I had a feeling that it was just missing something but couldn't see exactly what it was... Regards, Paul Paul Silveira wrote: Hello, I just installed Postgres 8.2 and was trying to add the xml2 contrib module. I went to the folder that contained

Re: [GENERAL] xml2 install problem

: assignment makes pointer from integer without a cast gmake: *** [xslt_proc.o] Error 1 The advice was to include these libraries. Is there anything else that needs to be configured once that's done to make it work? Thanks in avance, Paul Paul Silveira wrote: Hello, I just installed

[GENERAL] xml2 install problem

Hello, I just installed Postgres 8.2 and was trying to add the xml2 contrib module. I went to the folder that contained the contribs and attempted to run gmake. I got this error... [EMAIL PROTECTED] xml2]# gmake gcc -I/usr/include/libxml2 -fpic -I. -I../../src/include -D_GNU_SOURCE -c -o

Re: [GENERAL] shell script to populate array values

development... -Paul Paul Silveira wrote: Hello, I would like to create a shell script that would populate two variables with the return of a SELECT statement that would return two attributes... For example... #!/bin/bash SERVER_NAMES=`psql Admin -Upostgres -hMYSERVER -t

Re: [GENERAL] shell script to populate array values

the same thing... -Paul Paul Silveira wrote: Hello, I would like to create a shell script that would populate two variables with the return of a SELECT statement that would return two attributes... For example... #!/bin/bash SERVER_NAMES=`psql Admin -Upostgres -hMYSERVER -t

Re: [GENERAL] shell script to populate array values

-cSELECT '$SERVERCOLLECTIONTIMEID', column1 FROM mytable; The reason why I want to use the variable is because I want to eventually insert that data into a table that is looking for that ID value. Thanks in Advance... Paul Silveira wrote: Hello, I would like to create a shell script

[GENERAL] shell script to populate array values

Hello, I would like to create a shell script that would populate two variables with the return of a SELECT statement that would return two attributes... For example... #!/bin/bash SERVER_NAMES=`psql Admin -Upostgres -hMYSERVER -t -cSELECT servername, instanceport from server where

[GENERAL] Using SAN Splits to instantly copy a DB

Hello, Does anyone know if it is possible to use SAN Splitting (the function of splitting a mirror of disks so that there are two idential copies of a Postgres Instance)? The reason that I ask is because I'm working on a Hashing database to scale postgres to the moon and I'd like to be able to