Clarification needed

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@fetter.org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter

Remember to vote!

Look at http://www.postgresql.org/docs/8.1/interactive/catalogs.html

Specially on pg_attribute, pg_class and pg_type table. Or you can use
some features in the psql.

Zdenek

Indira Muthuswamy napsal(a):

"Indira Muthuswamy" wrote:

Can anyone of you help me in finding the datatype of a particular column in
a table in Postgres?

Thanks and Regards,
M.Indira

You're almost in the right place, but you'd be better off asking this
question in the pgsql-general or perhaps pgsql-novice. This mailing
list is for talking about modifications to the actual database engine.

Drew

In psql,
psql>\d tableName

Query is

SELECT pg_catalog.format_type(a.atttypid, a.atttypmod) from
pg_attribute a, pg_class c where a.attrelid =c.oid and
c.relname='TableName' and a.attname='ColName';

Zdenek Kotala wrote:

you should use schemaname.tablename syntax if you are using schema

**

See also information_schema and newsysviews on pgFoundry.
On Wed, Oct 11, 2006 at 10:15:22AM +0200, Zdenek Kotala wrote:

Look at http://www.postgresql.org/docs/8.1/interactive/catalogs.html

Specially on pg_attribute, pg_class and pg_type table. Or you can use
some features in the psql.

Zdenek

Indira Muthuswamy napsal(a):

Hai,

Can anyone of you help me in finding the datatype of a particular column
in a table in Postgres?

Thanks and Regards,
M.Indira

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)