>
> Is there a way of testing for membership in an int2vector-field? For
> example:
> select column, "prim.key" from ... where pg_attribute.attnum in
> pg_index.indkey
> ??
>
I think so. Refer to the array section of the documentation.
Extract:
To search for a value in an array, you must check
Hi.
I'm trying to write a select statement that does the following;
select all tables in my database;
for each table, select all columns, and tell me if the column is a
primary key
in the table.
I've tried this by querying pg_class, pg_index and pg_attribute, but I
have a problem when I this
