| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: psql man page error? |
| Date: | 2006-12-05 23:16:52 |
| Message-ID: | 200612052316.kB5NGq307285@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > I think the proper fix is:
>
> > <application>psql</application>, like this: <literal>echo -e
> > "\\x\nSELECT * FROM foo;" | psql</literal>.
>
> > I think all modern operating systems understand echo -e at this point.
>
> No, they don't, and neither does the Single Unix Spec:
> http://www.opengroup.org/onlinepubs/007908799/xcu/echo.html
>
> So your version of the example depends on non-standards-compliant
> echo behavior, which is not better than before.
Well, at least my example works on _some_ operating systems, while the
previous worked on none of them, so it is _better_.
I can't think of a good way to do this except converting the example to
a <programlisting> block that will not change newlines:
echo '\x
SELECT * FROM foo;' | psql
Is that what people want?
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2006-12-05 23:25:42 | Re: psql man page error? |
| Previous Message | Simon Riggs | 2006-12-05 19:57:55 | Re: psql man page error? |