Re: Getting Metadata - Mailing list pgsql-docs

From matt
Subject Re: Getting Metadata
Date
Msg-id 008401c1e73a$49cf0cf0$b9d47e82@puckster
Whole thread Raw
In response to Re: COPY Command  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-docs
I need to be able to do this-

array columns = QUERY metadata ON table_name RETURN column_names;

That is, I am not sure how to query the metatables.  I need to get all the
column names for a given table (I'll have the name of the table) and put
that into an array, so I can access it while I am exporting the data from a
table.

I need to couple the col_name with the data for each column, to get my XML
extention to the copy command to work.

thanks
matt



pgsql-docs by date:

Previous
From: Leif Jensen
Date:
Subject: Re: [GENERAL] Migrating Oracle to PostgreSQL
Next
From: "matt"
Date:
Subject: Re: Getting Metadata