Postgres Pro
Downloads
Home   >   mailing lists

all non-PK columns from information schema - Mailing list pgsql-general

From Tarlika Elisabeth Schmitz
Subject all non-PK columns from information schema
Date
Msg-id 20111115085928.78c335e3@dick.coachhouse
Whole thread Raw
List pgsql-general
Tree view 
I'd  like to select all column names for a specific table except those
that are part of the PK.

I know I need to somehow join information_schema.columns,
key_column_usage and table_constraints but how?

--

Best Regards,
Tarlika Elisabeth Schmitz

pgsql-general by date:

Previous
From: Robins Tharakan
Date:
Subject: Re: Client SQL Tool
Next
From: John R Pierce
Date:
Subject: Re: how to adjust auto increment id offset?