Re: [GENERAL] Q: Truncated output

2000-06-01 Thread Ross J. Reedstrom
On Thu, Jun 01, 2000 at 08:51:13PM +, 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 w

Re: [GENERAL] Q: Truncated output

2000-06-01 Thread leonbloy
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] > 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

[GENERAL] Q: Truncated output

2000-06-01 Thread Elliot Finley
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