Re: Q: Truncated output

A quick and dirty trick, is to make a dump of the schema
of the database (or the table):

postgres# pg_dump -s [-t employee] <my-db-name>  > db.dump.schema

Regards

Hernan Gonzalez
Buenos Aires, Argentina


>  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!
>