Q: Truncated output

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!

Responses

Browse pgsql-general by date

  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