Copyright notice

Hello, I am trying to add an extention to the COPY command, to all it to
take in XML documents and export values from the table as XML documents. I
have having trouble figuring out the parser, and how this command works in
general. I am familiar with adding new functions to the system, but
navigating and figuring out the interplay of everything going on within
postgrestsql is a bit daunting.

matt

Vince Vielhaber wrote:

I was just pointed out to me that the copyright notice on our docs is:

Copyright 1996-2001 ...

Shouldn't that be 2002?

I usually go around and change all the C files, including does. I will
add it to my list.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Does anyone have any idea about this? Can I just post this question on
[HACKERS]?

matt
----- Original Message -----
From: "matt" <vagnoni@uiuc.edu>
To: <pgsql-docs@postgresql.org>
Sent: Monday, April 15, 2002 1:03 PM
Subject: [DOCS] COPY Command

Hello, I am trying to add an extention to the COPY command, to all it to
take in XML documents and export values from the table as XML documents.

I

I thought I had info in TODO.detail on this, but I don't. There is
/contrib/xml. Doing the output with COPY isn't hard. Input in a problem
because XML is more hierarchical, rather than relational.

---------------------------------------------------------------------------

matt wrote:

Does anyone have any idea about this? Can I just post this question on
[HACKERS]?

matt
----- Original Message -----
From: "matt" <vagnoni@uiuc.edu>
To: <pgsql-docs@postgresql.org>
Sent: Monday, April 15, 2002 1:03 PM
Subject: [DOCS] COPY Command

Hello, I am trying to add an extention to the COPY command, to all it to
take in XML documents and export values from the table as XML documents.

I

have having trouble figuring out the parser, and how this command works in
general. I am familiar with adding new functions to the system, but
navigating and figuring out the interplay of everything going on within
postgrestsql is a bit daunting.

matt

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

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

That is how do i access pg_attribute within a program?

Also, are the columns stored in order within pg_attribute?

thanks
matt

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.

So, to do an internal query, I can just do:

char * query = "SELECT column from pg_attributes WHERE pg_attributes.table =
table_name";

PGresult *result; <--where is PGresult stored?? what do i need to include
to get this struct?
result = PSQLexec(query);

What's the difference between PSQLexec and pg_exec?

And then, how do i access the information? I see commands like pg_result in
src/interfaces/libpgtcl/pgtclCmds.c but are these backend commands that I do
run inside a given function? the pg_stuff looks almost like front end
stuff...

sincerly,
matt

Vince Vielhaber wrote:

I was just pointed out to me that the copyright notice on our docs is:

Copyright 1996-2001 ...

Shouldn't that be 2002?

Done.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026