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!