Re: Limit A Table To 1 Row - Mailing list 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