From: | Paul Silveira <plabrh1(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Extracting Index Creation Script |
Date: | 2007-10-24 13:56:11 |
Message-ID: | 13384579.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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:
>
> 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
>
>
--
View this message in context: http://www.nabble.com/Extracting-Index-Creation-Script-tf4680848.html#a13384579
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | rihad | 2007-10-24 13:59:20 | 8.3b1 in production? |
Previous Message | Magnus Hagander | 2007-10-24 13:52:37 | Re: using libpq.lib in Microsoft C++ (managed) |