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 UseGreetings:
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