pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Re: Getting Metadata 3+ messages / 2 participants [nested] [flat]
* Re: Getting Metadata @ 2002-04-19 00:36 matt <vagnoni@uiuc.edu> 0 siblings, 0 replies; 3+ messages in thread From: matt @ 2002-04-19 00:36 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Getting Metadata @ 2002-04-19 00:47 matt <vagnoni@uiuc.edu> 2002-04-19 01:35 ` Re: Getting Metadata Roberto Mello <rmello@cc.usu.edu> 0 siblings, 1 reply; 3+ messages in thread From: matt @ 2002-04-19 00:47 UTC (permalink / raw) To: pgsql-docs That is how do i access pg_attribute within a program? Also, are the columns stored in order within pg_attribute? thanks matt ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Getting Metadata 2002-04-19 00:47 Re: Getting Metadata matt <vagnoni@uiuc.edu> @ 2002-04-19 01:35 ` Roberto Mello <rmello@cc.usu.edu> 0 siblings, 0 replies; 3+ messages in thread From: Roberto Mello @ 2002-04-19 01:35 UTC (permalink / raw) To: matt <vagnoni@uiuc.edu>; +Cc: 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-04-19 01:35 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2002-04-19 00:36 Re: Getting Metadata matt <vagnoni@uiuc.edu> 2002-04-19 00:47 Re: Getting Metadata matt <vagnoni@uiuc.edu> 2002-04-19 01:35 ` Roberto Mello <rmello@cc.usu.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox