Postgres Pro
Downloads
Home   >   mailing lists

Thread: SQL reference card

SQL reference card

From
Bob Vloon
Date:
Hello,

I'm looking for a reference card for SQL. I've searched quite a lot, but a
simple card
in PostScript/PDF seems to be hiding for me ;)

Anyone??

Thanx in advance,
 Bob..

Re: SQL reference card

From
"Josh Berkus"
Date:
Bob,

> I'm looking for a reference card for SQL. I've searched quite a lot,
> but a
> simple card
> in PostScript/PDF seems to be hiding for me ;)

It's not hiding from you.  There isn't one.  It'd be a little hard to
reduce all of SQL to a two-sided card.  The definition of SELECT alone
would take up one side ....

There is a company that does 8.5"x11" reference cards and sells them in
tech/academic bookstores.  I don't know the name, but you could try your
nearest major bookstore, and see if they have SQL as well as MS Office
and VBA.

Failing that, you can write your own and post it to
Techdocs.postgresql.org.  That's what open source is all about!

-Josh


______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco
Attachment

Re: SQL reference card

From
Bruce Momjian
Date:
Josh Berkus wrote:
> Bob,
>
> > I'm looking for a reference card for SQL. I've searched quite a lot,
> > but a
> > simple card
> > in PostScript/PDF seems to be hiding for me ;)
>
> It's not hiding from you.  There isn't one.  It'd be a little hard to
> reduce all of SQL to a two-sided card.  The definition of SELECT alone
> would take up one side ....
>
> There is a company that does 8.5"x11" reference cards and sells them in
> tech/academic bookstores.  I don't know the name, but you could try your
> nearest major bookstore, and see if they have SQL as well as MS Office
> and VBA.
>
> Failing that, you can write your own and post it to
> Techdocs.postgresql.org.  That's what open source is all about!

Is this what you had in mind?  It is a psql '\h *' dump of the syntax
commands, run through vgrind with pgsql keywords, then placed for per
page.

--
  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