On Tue, Nov 15, 2011 at 11:29 AM, Richard Broersma <
richard.broer...@gmail.com> wrote:
> On Tue, Nov 15, 2011 at 8:00 AM, Tarlika Elisabeth Schmitz
> wrote:
> > Interesting. I have previously used the information_schema for similar
> > queries.
> >
> > What are the pros and cons for using either
On Tue, Nov 15, 2011 at 8:00 AM, Tarlika Elisabeth Schmitz
wrote:
> Interesting. I have previously used the information_schema for similar
> queries.
>
> What are the pros and cons for using either pg_catalog or
> information_schema?
My understanding is that pg_catalog tables and views *can* chan
On Tue, 15 Nov 2011 09:26:35 -0600
Mike Blackwell wrote:
>On Tue, Nov 15, 2011 at 02:59, Tarlika Elisabeth Schmitz <
>postgres...@numerixtechnology.de> wrote:
>
>> I'd like to select all column names for a specific table except
>> those that are part of the PK.
>> --
>> Tarlika Elisabeth Schmitz
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
--
Sent via pgsql-general mailing list (pgsql-ge
