Re: Getting Metadata

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: matt <vagnoni(at)uiuc(dot)edu>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Getting Metadata
Date: 2002-04-19 01:35:26
Message-ID: 20020419013526.GB16915@cc.usu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Thu, Apr 18, 2002 at 07:47:04PM -0500, matt wrote:
> That is how do i access pg_attribute within a program?

With a regular SELECT.

> Also, are the columns stored in order within pg_attribute?

Go into psql and type "\d pg_attribute" like any other table.

If you want to see how psql does its internal queries (e.g. when you
run '\d table') run psql with the -E switch.

-Roberto

--
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
Newsbytes - Microsoft announce EDLIN for Windows.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Roberto Mello 2002-04-19 01:41:51 Re: [DOCS] [GENERAL] Migrating Oracle to PostgreSQL
Previous Message matt 2002-04-19 00:47:04 Re: Getting Metadata