Re: "man psql" \set documentation error
От | Bruce Momjian |
---|---|
Тема | Re: "man psql" \set documentation error |
Дата | |
Msg-id | 200202181742.g1IHg1x02806@candle.pha.pa.us обсуждение исходный текст |
Ответ на | "man psql" \set documentation error (Derrell.Lipman@UnwiredUniverse.com) |
Ответы |
Re: "man psql" \set documentation error
|
Список | pgsql-docs |
Derrell.Lipman@UnwiredUniverse.com wrote: > Running an application and \set'ing its output in a variable requires use of > the backtick '`' operator. Under the heading "SQL INTERPOLATION", the > examples should be as follows (the difference being use of backticks instead > of single quotes around the command to be executed): > > Current (wrong): > testdb=> \set content '\'' 'cat my_file.txt' '\'' > > Correct: > testdb=> \set content '\'' `cat my_file.txt` '\'' > > > > Current (wrong): > testdb=> \set content 'sed -e "s/'/\\\\\\'/g" < my_file.txt' > > Correct: > testdb=> \set content `sed -e "s/'/\\\\\\'/g" < my_file.txt` > I just checked and it looks fine in current sources. Does it look right in your browser: http://candle.pha.pa.us/main/writings/pgsql/sgml/app-psql.html -- 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
В списке pgsql-docs по дате отправления: