[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 -- V

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 Silv

[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 c

[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 -c"SELECT servername, instanceport from server where serverclas

Re: [GENERAL] shell script to populate array values

nting to do 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/b

Re: [GENERAL] shell script to populate array values

ql -Upostgres -hMYSERVER -t -c"SELECT '$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 wrot

Re: [GENERAL] shell script to populate array values

nks for the multiple examples in your last post. Those are definitely going to come in handy for some of my other development... -Paul Paul Silveira wrote: > > Hello, > > I would like to create a shell script that would populate two variables > with the return of

[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 xsl

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 folde

Re: [GENERAL] xml2 install problem

tion) xslt_proc.c:117: warning: 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 Silv

[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 th

[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" s