I'm a newbie running PostgreSQL 8.1 and pgAdmin 3 (Version 1.2.2) on Debian Sarge. I want to set up a foriegn key in one of my tables. This foreign key will reference the primary key of another table in the database. The referrenced table uses the bigserial datatype to generate its keys. The PostgreSQL manual said that this corresponded to the bigint datatype. However I didn't see a bigint data type in pgAdmin 3. I did see a "int8" data type. I know the "8" referes to the number of bytes used to store the integer, or something like that. If I set the data type of the foreign key to "int8" in pgAdmin, will this correspond to the integer type stored by the bigserial data type? In other words, are int8 and bigint the same thing? Thanks for the clarification. Scott Huey
