Re: python script for crosstab queries in PostgreSQL

If it's only 3k in size, you could probably post it here as an attachment.
Heck, there're discussion threads with text that size in them all the
time.  8-)

On Thu, 26 Jun 2003, Andrew Gould wrote:

> I just finished a python script that performs a
> crosstab query in PostgreSQL.  Since I do most of my
> analysis using MS Access, this was more of an academic
> excercise than anything else.
>
> I wrote the script externally to PostgreSQL using
> PyGreSQL because:
>
> 1. The script can be copied and saved as different
> queries; and
> 2. I'm am, admittedly, squeamish about new languages
> and compiling additional features into any
> application. (There is no 'IS' in 'CPA').
>
> The script has the following features/limitations:
>
> 1. The user defines all database connection and query
> variables near the top of the file.
> 2. The script builds the sql query from defined
> variables.
> 3. SELECT INTO is used to store the result set in a
> table. There is a variable to make the table
> temporary.
> 4. The script does not allow for joining tables.
> 5. You can only use values from one column for
> crosstab column headers.
> 6. I haven't learned about handling errors yet.
>
> Limitations 4 and 5 can be worked around, I've done
> both in MS Access; but the opportunity for errors was
> too great for the first run.
>
> As for #6, I wasn't interested in making errors!  ;-)
> (Yes, I know....I'll add error handling to my
> 'learning' list.)
>
> If anyone is interested in the script, let me know.
> It's under 3K in size.
>
> Andrew Gould
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>