Skip site navigation (1) Skip section navigation (2)

Quick System Catalog Query Question

From: Terry Hampton <thampton(at)limacorp(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Quick System Catalog Query Question
Date: 2004-03-29 21:51:30
Message-ID: 40689A62.5080507@limacorp.com (view raw or flat)
Thread:
Lists: pgsql-admin

All,

select attname, atttypmod, atttypid  from pg_attribute where 
attrelid=3701787 and attnum > 0;

returns:

   attname   | atttypmod | atttypid
-------------+-----------+----------
  acct_name  |       132 |     1043
  grp               |        54 |     1043
  name           |       260 |     1043
  id                  |        54 |     1043
  proc_by        |        54 |     1043
  fldnames      |        -1 |       25
  flddata          |        -1 |       25

			
	I can't determine what SQL to which system catalog will associate
	"1043" to "varchar"   and  "25" to "text"


	many thanks for you help

		7.3.2  on Linux


			Terry





Terry L. Hampton
Project Manager
LimaCorp, LLC   www.limacorp.com
513.587.1874



Responses

pgsql-admin by date

Next:From: Jaime CasanovaDate: 2004-03-29 21:56:22
Subject: Re: Raw vs Filesystem
Previous:From: Lamar OwenDate: 2004-03-29 21:41:20
Subject: Re: postgresql.conf file and logging questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group