Re: Creating users with name and email

Andreas Burkhardt <rootshell@web.de> writes:
> 1. adding the new columns to pg_authid?

> 2. CREATE TABLE users (
> email VARCHAR ) INHERITS (pg_authid);

> 3. CREATE TABLE users (
> rolname VARCHAR REFERENCES pg_authid ( rolname ),
> email VARCHAR );

Actually, none of those will work.  You can't modify system catalogs (at
least not without a lot of internals work).  You can make a users table
OK, you just can't set up a foreign-key linkage to pg_authid ...

            regards, tom lane