From: | efinley(at)efinley(dot)com (Elliot Finley) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Q: Truncated output |
Date: | 2000-06-01 20:51:13 |
Message-ID: | 3943cc14.69397519@mail.afnetinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)efinley(dot)com) Weird Science!
From | Date | Subject | |
---|---|---|---|
Next Message | leonbloy | 2000-06-01 21:10:45 | Re: Q: Truncated output |
Previous Message | Bruce Momjian | 2000-06-01 20:25:55 | Re: shared memory |