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
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
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
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
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
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
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
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
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
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
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
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
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
13 matches
Mail list logo