Joe <svn@xxxxxxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
