>>I apologize for perhaps missing the obvious, but how do you get the listings package to colorize the source code? This same question has appeared numerous times with the same link to the FAQ. It would really be nice to see an example.

> Here are two .sty files, and sample input that work for me; I think
> that
> you need to have a recent `listings' for this to go.

> I have trouble viewing the colored text in GhostScript so I convert
> to PDF instead.

> HTH,
> Jim

> =====ham_notes.sty=======
>  %\RequirePackage{dvidrv}
> \RequirePackage{color}
> %\definecolor{mediumblue}{rgb}{0.00,0.00,0.804}
> \definecolor{chocolate}{rgb}{0.82,0.41,0.18} % color 176
> \definecolor{pythoncolor}{rgb}{0.82,0.41,0.18}

> \definecolor{darkolivegreen}{rgb}{0.333,0.420,0.184} %color 116 (GI
> color?)
> \definecolor{sqlcolor}{rgb}{0.333,0.420,0.184} %color 116 (GI color?)

> \definecolor{sienna}{rgb}{0.627,0.322,0.176} %color 168 (coffee
> color?)
> \definecolor{javacolor}{rgb}{0.627,0.322,0.176} %color 168

> \definecolor{stringcolor}{rgb}{0.25,0.25,0.25}
> \definecolor{textcolor}{rgb}{0.25,0.25,0.25}

> %\definecolor{indianred3}{rgb}{0.804,0.333,0.333} %color 414
> \definecolor{indianred3}{rgb}{0.933,0.388,0.388} %color 413
> \definecolor{htmlcolor}{rgb}{0.933,0.388,0.388} %color 413

> \definecolor{mediumseagreen}{rgb}{0.477,0.702,0.441} %color 122
> \definecolor{shellcolor}{rgb}{0.477,0.702,0.441} %color 122

> \definecolor{brown}{rgb}{0.647,0.165,0.165}   % color 178
> \definecolor{slateblue4}{rgb}{0.278,0.235,0.545}   % color 279
> \definecolor{perlcolor}{rgb}{0.278,0.235,0.545}
> %\definecolor{shellcolor}{rgb}{0.0,0.25,0.0}
> \definecolor{htmlcolor}{rgb}{0.99,0,0} % red
> \definecolor{lightslategrey}{rgb}{0.467,0.533,0.600} %color 52
> \definecolor{xmlcolor}{rgb}{0.99,0,0} % red
> \definecolor{goldenrod}{rgb}{0.855,0.647,0.125} %color 159
> %\definecolor{sqlcolor}{rgb}{0.071,0.416,0.173} % a dark green

> \usepackage{listings}
> \lstloadlanguages{Python,SQL,csh,HTML}

> \lstdefinestyle{sql}{language=SQL,
>         %labelstyle=\tiny,labelstep=5,labelsep=7pt,
>         keywordstyle=\color{sqlcolor},
>         ndkeywordstyle=\color{sqlcolor},
>         identifierstyle=\color{sqlcolor},
>         stringstyle=\color{sqlcolor}}
> \lstdefinestyle{python}{language=Python,
>         %labelstyle=\tiny,labelstep=5,labelsep=7pt,
>         keywordstyle=\color{pythoncolor},
>         ndkeywordstyle=\color{pythoncolor},
>         identifierstyle=\color{pythoncolor},
>         stringstyle=\color{pythoncolor}}
> \lstdefinestyle{text}{language=,
>         keywordstyle=\color{textcolor},
>         ndkeywordstyle=\color{textcolor},
>         identifierstyle=\color{textcolor},
>         stringstyle=\color{textcolor}}
> \lstdefinestyle{shell}{language=csh,
>         keywordstyle=\color{shellcolor},
>         ndkeywordstyle=\color{shellcolor},
>         identifierstyle=\color{shellcolor},
>         stringstyle=\color{shellcolor}}
> \lstdefinestyle{html}{language=HTML,
>         keywordstyle=\color{htmlcolor},
>         ndkeywordstyle=\color{textcolor},
>         identifierstyle=\color{textcolor},
>         stringstyle=\color{textcolor},
>         keywordsinside=<>}
> \AtBeginDocument{%
>         \lstset{%
>         indent=15pt,
>         basicstyle=\ttfamily\small,
>         %keywordstyle=\color{blue},
>         %ndkeywordstyle=\color{blue},
>         %identifierstyle=\color{blue},
>         %stringstyle=\color{blue},
>         stringspaces=false}}
> =====lstlang0.sty====
> % lstlang0.sty
> % language definitions for the listings package
> \lst@definelanguage{text}%
>  {keywords={},ndkeywords={}}
> ====lst_test.tex===
> \documentclass{book}
> \usepackage{color}
> \usepackage{ham_notes}
> \usepackage{url}
> \usepackage{hyperref}

> \newcommand{\pg}{PostgreSQL}

> \title{KE1AZ's Internet Linux Log}
> \author{Jim Hefferon}

> \begin{document}
> \maketitle

> \chapter{Making the Database}

> \section{Making the State Database}
> \href{http://www.google.com}{Google} found
> this file of state and possession abbreviations that
> on the web site of the US Postal Service.
> \begin{lstlisting}[style=text]{}
> State/Possession                Abbreviation

> ALABAMA                         AL
> ALASKA                          AK
> AMERICAN SAMOA                  AS
> ARIZONA                         AZ

>  ..

> WEST VIRGINIA                   WV
> WISCONSIN                       WI
> WYOMING                         WY

> Military "State"                Abbreviation

> Armed Forces Africa             AE
> Armed Forces Americas           AA
> (except Canada)
> Armed Forces Canada             AE
> Armed Forces Europe             AE
> Armed Forces Middle East        AE
> Armed Forces Pacific            AP
> \end{lstlisting}
> I edited out the two title lines
> (`Military~\ldots' and `State/Possession~\ldots') along with the blank
> lines,
> and adjusted the `except Canada' line.
> Also,
> I don't know anything about the postal codes for the military cases,
> but I see that three of them share a designation.
> I combined those three.

> The \url{create_states.sql} script file
> \begin{lstlisting}[style=sql,firstlabel=1]{}
> CREATE TABLE state_types (
>        type  text,
>        PRIMARY KEY(type)
> );

> INSERT INTO state_types (type) VALUES ('state');
> INSERT INTO state_types (type) VALUES ('possession');
> INSERT INTO state_types (type) VALUES ('military');

> CREATE TABLE states (      
>        abbrev       CHAR(2) NOT NULL,
>        name         text NOT NULL,
>        status       text,
>        PRIMARY KEY(abbrev),
>        FOREIGN KEY(status) REFERENCES state_types
> );
> \end{lstlisting}
> run from the command line
> \begin{lstlisting}[style=shell]{}
> [jim@millstone pg]$ psql jim -a -fcreate_states.sql    
> \end{lstlisting}
> will make the two tables.
> The \verb!state_types! is how I limit
> \verb!states.status! to only those three values.

> Note that I had to create the \verb!state_types! first or else
> \pg\ objects to referencing them as foreign keys.

> Next I need to get the data into the database.
> Then this Python script
> \begin{lstlisting}[style=python]{}
> #!/usr/bin/python
> # read_states.py
> #  Read the list of states and abbreviations
> # 20-Nov-2001 Jim Hefferon j...@joshua.smcvt.edu
> import string

> infile_name="abbr_state.txt"
> infile=open(infile_name,'r')
> outfile_name="populate_states.sql"
> outfile=open(outfile_name,'w')

> for x in ('state','possession','military'):
>     outfile.write("INSERT INTO state_types (type) VALUES ('%s');\n" %
> (x,))

> while  1:
>     line=infile.readline()[:-1]
>     if not line:
>         break
>     fields=string.split(line)
>     outfile.write("INSERT INTO states (abbrev,name,status) VALUES
> ('%s','%s','%s');\n" %
> (fields[-1],string.capwords(string.join(fields[0:-1])),'state'))
> infile.close()
> outfile.close()
> \end{lstlisting}
> run from the command line
> \begin{lstlisting}{text}
> [jim@millstone pg]$ ./read_states.py
> \end{lstlisting}
> gave me a file of \verb!INSERT! statements.
> I've decided to produce the SQL script file.
> \begin{lstlisting}[style=sql]{}
> INSERT INTO states (abbrev,name,status) VALUES
> ('AL','Alabama','state');
> INSERT INTO states (abbrev,name,status) VALUES
> ('AK','Alaska','state');
> INSERT INTO states (abbrev,name,status) VALUES ('AS','American
> Samoa','possession');
>  ...
> INSERT INTO states (abbrev,name,status) VALUES
> ('WY','Wyoming','state');
> INSERT INTO states (abbrev,name,status) VALUES ('AE','Armed Forces
> Africa, Canada, Europe, And The Middle East','military');
> INSERT INTO states (abbrev,name,status) VALUES ('AA','Armed Forces
> Americas (except Canada)','military');
> INSERT INTO states (abbrev,name,status) VALUES ('AP','Armed Forces
> Pacific','military');
> \end{lstlisting}
> Note that, as produced by the script, everything is a `state', but I
> edited it by hand to change some to `possession' or `military'.
> (I called Washington DC a `possession' even though it didn't seem
> right,
> since it isn't either of the other two.)
> \end{document}