r == richard.broer...@gmail.com writes: r> On Thu, Jun 4, 2009 at 1:13 PM, Brandon Metcalf r> <bran...@geronimoalloys.com> wrote: r> > Is there a way when creating a table to limit it to one row? ?That is, r> > without using a stored procedure?
r> Sure just add a check constraint along the lines of: r> CONSTRAINT Only_one_row r> CHECK( tableuniqueid = 1 ); --assuming you row has a unique id of 1 Got it. Currently, it doesn't have a column for an ID, but I can add one if this is the only way. -- Brandon -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
