Re: Data type that corresponds to bigserial...

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(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US