On 10 May 2010, at 6:02, Boyd, Craig wrote:
> I have been using PostgreSQL for a short while, but I have not had to use the
> pg_catalog tables before and the columns are a little cryptic to me. I think
> it ties to pg_class, but I am not sure how to relate them. Also, I have not
> had a chan
I have been using PostgreSQL for a short while, but I have not had to
use the pg_catalog tables before and the columns are a little cryptic to
me. I think it ties to pg_class, but I am not sure how to relate them.
Also, I have not had a chance to us the \dt function. Can you give me
some poi
"Boyd, Craig" writes:
> I am trying to pull together some general information about indices
> (indexes?) for a particular table.
> I need the following: Index Name, Table Name, Column Name,
> Unique/Non-Unique, and ordinal position in the index.
> The information_schema.key_column_usage gets me
