SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-18-2008, 10:37 AM
| ||||
| ||||
 Re: psql slash# command This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --------------------------------------------------------------------------- Sibte Abbas wrote: > On 9/9/07, Sibte Abbas <sibtay@gmail.com> wrote: > > Attached is the patch for the TODO item mentioned at > > http://archives.postgresql.org/pgsql...9/msg00352.php > > > > The command has the following synopsis: > > > > \#: displays the command history. Like \s but prefixes the lines with line > > numbers > > > > \# <line_no>: executes the command(if any) executed at the line specified by > > line_no > > > > regards, > > -- > > Sibte Abbas > > > > > > The attached patch adds the following new functionality: > > \#e <lineno>: Will open the command at the given lineno in an editor. > \#e with no lineno will behave exactly like \e. > > Example: > ===== > > psql> \# > > 199: create or replace function foo() returns integer as $$ > begin > return 10; > end; > $$language 'plpgsql'; > > 200: select version(); > > 201: select * from foo(); > > \# 200 > <select version() is executed> > > psql> \#e 199 > <the contents of lineno 199 are opened in the editor> > > Definitely not for 8.3, however I hope that it can be queued for 8.4. > > thanks, > -- > Sibte Abbas [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly      |
Linear Mode
