On Thu, Jun 4, 2009 at 1:13 PM, Brandon Metcalf
<brandon@geronimoalloys.com> wrote:
> Is there a way when creating a table to limit it to one row? That is,
> without using a stored procedure?
Sure just add a check constraint along the lines of:
CONSTRAINT Only_one_row
CHECK( tableuniqueid = 1 ); --assuming you row has a unique id of 1
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug