Data type that corresponds to bigserial...

From: Redefined Horizons <redefined(dot)horizons(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Data type that corresponds to bigserial...
Date: 2006-01-19 02:59:58
Message-ID: e24752a10601181859u35b252b2n8ac507d8507f613a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Larry Rosenman 2006-01-19 03:05:10 Re: Data type that corresponds to bigserial...
Previous Message Rod Taylor 2006-01-19 02:02:28 Re: No heap lookups on index