Postgres Pro
Downloads
Home   >   mailing lists

Thread: Q: Truncated output

Q: Truncated output

From
efinley@efinley.com (Elliot Finley)
Date:
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!

Re: Q: Truncated output

From
leonbloy@sinectis.com.ar
Date:
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!
>

Re: Q: Truncated output

From
"Ross J. Reedstrom"
Date:
On Thu, Jun 01, 2000 at 08:51:13PM +0000, Elliot Finley wrote:
> 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 |

Yeah, this is ugly. If you start up psql with the -E switch, you'll see the
queries the psql uses to get the info. Something like this will get what
you want:

select adsrc from pg_class c, pg_attribute,  pg_attrdef  where
adrelid=c.oid and attrelid=c.oid and attnum=adnum and relname ='employee'
and attname= 'employee_id';

Oh, a hint: if you used the 'serial' type to create the id, the sequence
is named <tablename>_<fieldname>_seq, unless it's to long, then it gets
truncated (fieldname first, then tablename)

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005