Getting started with postgresql

Walter Dnes waltdnes-SLHPyeZ9y/tg9hUCZPvPmw at
Sun Nov 20 05:57:13 UTC 2005

  I'm at the tail end of some experiments with de-noising digital photos
from my camera.

  My next personal project will be learning postgresql.  I am familiar
with Oracle SQL and PL/SQL as an end-user/programmer, but not as an
admin.  I'm not a CS, but at work I do write some read-only queries.
We've got MS-Access via ODBC as well, but once you get past the really
simple stuff, GUI "Query By Example" runs into a wall.  To give an idea
of where I'm at, my "claims-to-fame" are...

  - cross-tabbing table(s) *WITHOUT A SELF-JOIN*.  (!^%$#& umpteenth-
    order normalized table)

  - A hack for bypassing the PL/SQL 1-megabyte total output limit, and
    the 255 bytes-per-line limit, for programs launched from the SQL
    command prompt.

  - I managed to figure out how to SELECT ... BULK COLLECT INTO an
    "INDEX BY" table.  It's so easy once you see it done once.

  Anyone aware of any "postgresql user groups" in the Toronto area?
What are the best quick guides to getting started?  I've installed it
but haven't fired it up yet.  Are there any booby-traps to watch for?
E.g. ensure that it doesn't end up listening to external connections on
the internet?

Walter Dnes <waltdnes-SLHPyeZ9y/tg9hUCZPvPmw at> In linux /sbin/init is Job #1
My musings on technology and security at
The Toronto Linux Users Group.      Meetings:
TLUG requests: Linux topics, No HTML, wrap text below 80 columns

More information about the Legacy mailing list