From: | leonbloy(at)sinectis(dot)com(dot)ar |
---|---|
To: | efinley(at)efinley(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Q: Truncated output |
Date: | 2000-06-01 21:10:45 |
Message-ID: | 200006012110.SAA20037@rye.sinectis.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)efinley(dot)com) Weird Science!
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Shraibman | 2000-06-01 21:19:43 | Re: Postmaster won't -HUP |
Previous Message | Elliot Finley | 2000-06-01 20:51:13 | Q: Truncated output |