Re: audit information - Mailing list pgsql-novice

From Tom Lane
Subject Re: audit information
Date
Msg-id 24328.1114463329@sss.pgh.pa.us
Whole thread Raw
In response to Re: audit information  ("Keith Worthington" <keithw@narrowpathinc.com>)
List pgsql-novice
"Keith Worthington" <keithw@narrowpathinc.com> writes:
> Is there a reason not to store the user name as type name?

I'd use text; name is fixed-width and will waste space on trailing
blanks.  (Same objection to char(64) of course.)

> I am assuming there is no reason to use varchar(64).

Not particularly.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Keith Worthington"
Date:
Subject: Re: audit information
Next
From: Keith Worthington
Date:
Subject: Poor-man's enumeration type