Q: Truncated output
От | efinley@efinley.com (Elliot Finley) |
---|---|
Тема | Q: Truncated output |
Дата | |
Msg-id | 3943cc14.69397519@mail.afnetinc.com обсуждение исходный текст |
Ответы |
Re: Q: Truncated output
|
Список | pgsql-general |
I've just started using Postgres 6.5.2 and I'm trying to figure out a way to be able to see the complete 'type' for the 'employee_id' field. I can't remember which sequence I used in the 'nextval', so I need to be able to see which one is being used there. shift=> \d employee Table = employee +----------------------------------+----------------------------------+-------+ | Field | Type | Length| +----------------------------------+----------------------------------+-------+ | employee_id | int4 not null default nextval ( | 4 | | employer_id | int4 not null default 0 | 4 | | trading_unit_id | int4 not null default 0 | 4 | | username | text not null default '' | var | | password | text not null default '' | var | | first_name | text not null default '' | var | | last_name | text not null default '' | var | | address1 | text not null default '' | var | | address2 | text not null default '' | var | | city | text not null default '' | var | | state | text not null default '' | var | | zip | int4 not null default 0 | 4 | | email | text not null default '' | var | +----------------------------------+----------------------------------+-------+ Index: employee_pkey -- Elliot (efinley@efinley.com) Weird Science!
В списке pgsql-general по дате отправления: