Joe <svn@freedomcircle.net> writes:
> I have a MySQL database that I'm converting to PostgreSQL which has 10 columns
> with TINYINT type, i.e., a one-byte integer.
> I'm wondering what would be the best conversion choice for these columns:
> smallint, numeric(1), char(1), something else?
smallint, for sure; the others have more overhead.
> BTW, is TINYINT part of any SQL Standard?
No. If it were, we'd feel more urgency about implementing it ;-)
regards, tom lane