Thread: Marking a Column for Special Use
Greetings:
I have a scenario in which it would be quite convenient to mark about 20 existing columns in a table such that I can select those fields programatically, based on my flag, for some specialized processing. What I am trying to avoid is storing a list of columns somehere. Is there something like a "user area" in the underlying tables that define a column that could be safely utilized for this purpose?
I'm using PostgreSQL 8.3 on Red Hat.
TIA
--
Terry Tucker
Office: 336-372-6812
Can you make use of “COMMENT ON …”?
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Terry Lee Tucker
Sent: Tuesday, July 12, 2011 11:25 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Marking a Column for Special Use
Greetings:
I have a scenario in which it would be quite convenient to mark about 20 existing columns in a table such that I can select those fields programatically, based on my flag, for some specialized processing. What I am trying to avoid is storing a list of columns somehere. Is there something like a "user area" in the underlying tables that define a column that could be safely utilized for this purpose?
I'm using PostgreSQL 8.3 on Red Hat.
TIA
--
Terry Tucker
Office: 336-372-6812
On Tue, Jul 12, 2011 at 11:25:24AM -0400, Terry Lee Tucker wrote: > Greetings: > > I have a scenario in which it would be quite convenient to mark about 20 > existing columns in a table such that I can select those fields > programatically, based on my flag, for some specialized processing. What I am > trying to avoid is storing a list of columns somehere. Is there something like > a "user area" in the underlying tables that define a column that could be > safely utilized for this purpose? Sounds like you want a view, I think. A -- Andrew Sullivan ajs@crankycanuck.ca
On Tuesday, July 12, 2011 11:47:33 AM Andrew Sullivan wrote:
> On Tue, Jul 12, 2011 at 11:25:24AM -0400, Terry Lee Tucker wrote:
> > Greetings:
> >
> > I have a scenario in which it would be quite convenient to mark about 20
> > existing columns in a table such that I can select those fields
> > programatically, based on my flag, for some specialized processing. What
> > I am trying to avoid is storing a list of columns somehere. Is there
> > something like a "user area" in the underlying tables that define a
> > column that could be safely utilized for this purpose?
>
> Sounds like you want a view, I think.
>
> A
Yes, that is a good idea. Thanks...
--
The Tucker Family
Home: 336-372-5432
Mobile: 336-404-6987
On Tuesday, July 12, 2011 11:33:34 AM David Johnston wrote:
> Can you make use of "COMMENT ON ."?
>
>
>
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Terry Lee Tucker
> Sent: Tuesday, July 12, 2011 11:25 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Marking a Column for Special Use
>
>
>
> Greetings:
>
>
>
> I have a scenario in which it would be quite convenient to mark about 20
> existing columns in a table such that I can select those fields
> programatically, based on my flag, for some specialized processing. What I
> am trying to avoid is storing a list of columns somehere. Is there
> something like a "user area" in the underlying tables that define a column
> that could be safely utilized for this purpose?
>
>
>
> I'm using PostgreSQL 8.3 on Red Hat.
>
>
>
> TIA
That's a good idea. Thanks...
--
The Tucker Family
Home: 336-372-5432
Mobile: 336-404-6987