Re: psql latex and newlines

On Mon, Feb 13, 2012 at 02:50:12PM +0100, Wim Bertels wrote:
> On vr, 2012-02-10 at 19:25 -0500, Bruce Momjian wrote:
> > On Mon, Dec 12, 2011 at 07:15:12PM +0100, Wim Bertels wrote:
> > > Hallo,
> > >
> > > psql latex output format needs to differentiate between a newline and a
> > > tabularnewline.
> > >
> > > the problem arises when u have a field value that contains a newline
> > > character, when this field is not the first column, then all the data
> > > after this newline comes in the first column..
> > >
> > > u can try this out, writing a function or table,
> > > and then add 'enters' or newline in the COMMENT on this function or
> > > table.
> > >
> > > the \pset recordsep doesn't solve this, since the mistakes take place
> > > within the same record.
> >
> > Can you give me a self-contained test case I can use so I can use it to
> > fix the to code?
>
> Hi Bruce,
>
> i have attached some files:
> 1 sql file
> 1 corresponding output file
> 1 full latex file using the output of the above file
>
> i don't see and easy search/replace fix for this problem,
> maybe using the \multirow and \multicolumn options in latex is the most
> general solution,
> as all the others seems to need concrete dimensions (as width)
>
> http://www.google.com/search?client=ubuntu&channel=fs&q=newline+tabular
> +cell+latex&ie=utf-8&oe=utf-8
>
> http://andrewjpage.com/index.php?/archives/43-Multirow-and-multicolumn-spanning-with-latex-tables.html
>
> There is also a problem with long lines as u can test by uncommenting
> the t4bruce3 function.

Well, I was hoping you could tell me exactly how you wanted the behavior
changed and I could try to implement it in psql. I am afraid I don't
know enough about TeX to understand the isssue involved.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +