Re: Limit A Table To 1 Row

From: Richard Huxton <dev(at)archonet(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Limit A Table To 1 Row
Date: 2002-08-07 08:30:25
Message-ID: 200208070930.25591.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Cédric Dufour 2002-08-07 11:49:11 Views/queries and optimal indexes usage (cf. planner)
Previous Message Bhuvan A 2002-08-07 08:27:56 Effective usage without unique key -- suggestion