| From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Get table catalog from pg_indexes |
| Date: | 2022-11-27 21:31:44 |
| Message-ID: | 467d46cc-553f-0014-5a09-6ddf7ccf4fdb@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/27/22 11:22, Igor Korot wrote:
> Hi, ALL,
> Table pg_indexes does not contain a field for a catalog.
>
> So how do I get that?
>
> SELECT 1 FROM pg_indexes WHERE indexname = $1 AND tablename = $2 AND
> schemaname = $3
You did not look hard enough, or Google "postgresql pg_indexes".
test=# \d pg_indexes
View "pg_catalog.pg_indexes"
Column | Type | Collation | Nullable | Default
------------+------+-----------+----------+---------
*schemaname* | name | | |
*tablename* | name | | |
*indexname* | name | | |
tablespace | name | | |
indexdef | text | | |
https://www.postgresql.org/docs/current/view-pg-indexes.html
--
Angular momentum makes the world go 'round.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2022-11-27 21:55:48 | Re: Get table catalog from pg_indexes |
| Previous Message | David G. Johnston | 2022-11-27 18:57:13 | Re: Get table catalog from pg_indexes |