| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Indira Muthuswamy <indumuthu(at)gmail(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] Clarification needed |
| Date: | 2006-10-11 07:20:35 |
| Message-ID: | 20061011072035.GE9860@fetter.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
On Wed, Oct 11, 2006 at 12:26:19PM +0530, Indira Muthuswamy wrote:
> Hai,
>
> Can anyone of you help me in finding the datatype of a particular
> column in a table in Postgres?
Indira,
You'll want to look at the columns view in the information_schema.
http://www.postgresql.org/docs/current/static/information-schema.html
Cheers,
Dave.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravindran G - TLS, Chennai. | 2006-10-11 08:02:29 | Re: [PERFORM] Postgre 8.0 Installation - Issues |
| Previous Message | Jan Cruz | 2006-10-11 06:59:47 | Versioning/updating schema |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Teodor Sigaev | 2006-10-11 07:55:15 | Patch for Win32 blocking problem |
| Previous Message | Nikolay Samokhvalov | 2006-10-11 06:59:00 | Re: Fwd: pg_dump VS alter database ... set search_path ... |