Redefined Horizons wrote: > 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? > Yes.
LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
