From: Richard Huxton <dev@archonet.com>
To: pgsql-sql@postgresql.org
Subject: Re: Limit A Table To 1 Row
Date: Wed, 7 Aug 2002 09:30:25 +0100
Message-ID: <200208070930.25591.dev@archonet.com> (raw)
In-Reply-To: <web-1603081@davinci.ethosmedia.com>
References: <web-1603081@davinci.ethosmedia.com>
On Wednesday 07 Aug 2002 4:52 am, Josh Berkus wrote:
> However, you may want to reconsider this method of storing values in
> the database. What I do is create a table called global_admin:
>
> CREATE TABLE global_admin (
> value_name VARCHAR(30) NOT NULL PRIMARY KEY,
> value_format VARCHAR(30) NOT NULL,
> admin_value TEXT NULL
> );
I do as Josh does (which has got to put some doubts in Josh's mind) except I
add value_section and value_comment fields to make it easier for someone to
edit where necessary.
- Richard Huxton
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: dev@archonet.com
Subject: Re: Limit A Table To 1 Row
In-Reply-To: <200208070930.25591.dev@archonet.com>
* 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