Using meta-data for foreign key? - Mailing list pgsql-general

From Mike Blackwell
Subject Using meta-data for foreign key?
Date
Msg-id 48076B5E.4050707@sbcglobal.net
Whole thread Raw
Responses Re: Using meta-data for foreign key?  (Erik Jones <erik@myemma.com>)
List pgsql-general
I have an existing table in an app, along the lines of:

CREATE TABLE foo (
  name text,
  address text,
  some_numeric_info integer,
  <a bunch of additional fields here>
);

I now need to be able to associate additional information (e.g. printing
order) with each field.  Is it a bad idea to use the (fully qualified)
field name as a foreign key to link back to the table meta-data?  Is
there a better way?


pgsql-general by date:

Previous
From: "David Gagnon"
Date:
Subject: Re: Unable to add a new column to a table named "in" (look like a bug ...)
Next
From: "Jesus Becerra"
Date:
Subject: Re: Problems running PostGreSQL silent install