September 26th, 2007 by depesz | Tags: , , | 3 comments »
Did it help? If yes - maybe you can help me? Donate BTC to 19zPa5diT2LZqGtTi8f8bfApLn8rw9zBHx

for whatever reason i seem to remember names of files in postgresql documentation.

for example – i know, that psql docs are in app-psql.html, base page for configuration options is runtime-config.html. manual for “alter table" sql command, is in sql-altertable.html.

yet full page url (http://www.postgresql.org/docs/current/interactive/app-psql.html) is very long. on the other hand going to http://www.postgresql.org/docs/current/interactive/ is nto really useful, as i need to find specific page which i remember filename, but not necessarily title.

is there any solution? apparently, yes, simply follow these steps:

  1. go to http://www.postgresql.org/docs/current/interactive/
  2. bookmark this page
  3. go to “Bookmarks" -> “Organize Bookmarks…"
  4. find the bookmark that you just created, select it, and click on “properties" in toolbar
  5. in “keyword" enter letter “p" (without quotes)
  6. change url to http://www.postgresql.org/docs/current/interactive/%s.html
  7. press “ok" (you might want to create a special folder to hide this bookmark from standard view, as you will never use it directly)

and that's all. after you've done it, you can simply enter: “p app-psql" in your location edit box, press enter and you will be directed to correct page.

of course this trick works not only with postgresql docs. it can be used for google, search.postgresql.org, anything you want. but using this for postgresql manual will definitely shorten time spent on “going to manual" :)

  1. 3 comments

  2. # smyru
    Sep 26, 2007

    One can do similar thing in Opera as well. Add a dummy search engine. Just right click in a form field (even in this blog search field) and choose “Create a search”, click “Details” button, then remove the whole url pattern, and paste the pattern from point 6. Put a Name of choise for it, and add a keyword – “p” is fine.

    Now it’s ready, to test just press F8 to select location, then type “p app-psql”, and Enter.

  3. # Screwtape
    Sep 27, 2007

    When I was using PostgreSQL docs every day, I set up a keyword search like this:

    * Go to http://www.postgresql.org/docs/current/static/index.html
    * Right-click in the “Search Documentation” text-box in the top-right.
    * Choose “Add a keyword for this search” from the pop-up menu.
    * In the dialog that appears, you can set the name and keyword to whatever you like (I used “Search PostgreSQL docs” and “pg”, personally) then click Add.

    Personally, I find it easier to find the documentation on, say, COALECSCE by typing “pg coalesce” than typing “pg functions-conditional” :)

  1. 1 Trackback(s)

  2. Sep 28, 2007: Diamond Notes » Log Buffer #64: a carnival of the Vanities for DBAs

Leave a comment