psql editor temp file extension

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема psql editor temp file extension
Дата
Msg-id 1322541962.4595.4.camel@vanquo.pezone.net
обсуждение исходный текст
Ответы Re: psql editor temp file extension
Список pgsql-hackers
There was a question recently on a user list about how to configure an
editor to handle psql's editor temp files as SQL files.  While this is
doable with an advanced editor by reverse-engineering the file pattern
than psql uses, it would be easier if psql just added an extension
".sql".  Since both uses (\e and \ef) are actually SQL files, this
should not be a problem.  So I propose the attached patch.

diff --git i/src/bin/psql/command.c w/src/bin/psql/command.c
index 9cc73be..f885c1d 100644
--- i/src/bin/psql/command.c
+++ w/src/bin/psql/command.c
@@ -1879,10 +1879,10 @@ do_edit(const char *filename_arg, PQExpBuffer query_buf,
          */
 #endif
 #ifndef WIN32
-        snprintf(fnametmp, sizeof(fnametmp), "%s%spsql.edit.%d", tmpdir,
+        snprintf(fnametmp, sizeof(fnametmp), "%s%spsql.edit.%d.sql", tmpdir,
                  "/", (int) getpid());
 #else
-        snprintf(fnametmp, sizeof(fnametmp), "%s%spsql.edit.%d", tmpdir,
+        snprintf(fnametmp, sizeof(fnametmp), "%s%spsql.edit.%d.sql", tmpdir,
                "" /* trailing separator already present */ , (int) getpid());
 #endif


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Misleading CREATE TABLE error
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: psql editor temp file extension