From: Andreas <maps.on@gmx.net>
To: postgres list <pgsql-sql@postgresql.org>
Subject: How would I store little key-Nr to text lists?
Date: Sat, 10 Jul 2010 09:57:23 +0200
Message-ID: <4C3827E3.3080408@gmx.net> (raw)
Hi
how would I store little key-Nr to text lists?
Like e.g.
colors
1 red
2 green
3 blue
Maybe I later also need to add 4 yellow?
Obviously the numbers are used for foreign keys in data tables and the
texts appear in selects.
On the other hand users should chose from listboxes in an application so
I need to be able to read the (key, ext) tupels.
For now I use 2 column tables that in selects get joined to a data table.
Is there a more clever way ?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: maps.on@gmx.net
Subject: Re: How would I store little key-Nr to text lists?
In-Reply-To: <4C3827E3.3080408@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox