Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[GENERAL] Naming conventions

4 views
Skip to first unread message

Scott Briggs

unread,
May 15, 2012, 5:50:17 PM5/15/12
to
So this is purely anecdotal but I'm curious, what's with all the
different naming conventions? There's psql (for database
connections), pgsql (used for some dirs like /usr/pgsql-9.1 and this
mailing list), postgres (user and other references), and postgresql
(startup scripts).

Cheers,
Scott

--
Sent via pgsql-general mailing list (pgsql-...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Raymond O'Donnell

unread,
May 16, 2012, 5:08:03 AM5/16/12
to
On 15/05/2012 22:50, Scott Briggs wrote:
> So this is purely anecdotal but I'm curious, what's with all the
> different naming conventions? There's psql (for database
> connections), pgsql (used for some dirs like /usr/pgsql-9.1 and this
> mailing list), postgres (user and other references), and postgresql
> (startup scripts).

... and don't forget (maybe oddest of all) libpq! :-)

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie

Bruce Momjian

unread,
May 24, 2012, 9:21:30 PM5/24/12
to
On Wed, May 16, 2012 at 10:08:03AM +0100, Raymond O'Donnell wrote:
> On 15/05/2012 22:50, Scott Briggs wrote:
> > So this is purely anecdotal but I'm curious, what's with all the
> > different naming conventions? There's psql (for database
> > connections), pgsql (used for some dirs like /usr/pgsql-9.1 and this
> > mailing list), postgres (user and other references), and postgresql
> > (startup scripts).

Uh, the original Berkeley project name was postgres, pgsql is used as a
short-hand for PostgreSQL, and psql is short for 'PostgreSQL SQL
Monitor'.

> ... and don't forget (maybe oddest of all) libpq! :-)

libpq originally supported Postgres QUEL:

http://en.wikipedia.org/wiki/QUEL_query_languages

--
Bruce Momjian <br...@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

Raymond O'Donnell

unread,
May 25, 2012, 4:49:18 AM5/25/12
to
On 25/05/2012 02:21, Bruce Momjian wrote:
> On Wed, May 16, 2012 at 10:08:03AM +0100, Raymond O'Donnell wrote:
>> On 15/05/2012 22:50, Scott Briggs wrote:
>>> So this is purely anecdotal but I'm curious, what's with all the
>>> different naming conventions? There's psql (for database
>>> connections), pgsql (used for some dirs like /usr/pgsql-9.1 and this
>>> mailing list), postgres (user and other references), and postgresql
>>> (startup scripts).
>
> Uh, the original Berkeley project name was postgres, pgsql is used as a
> short-hand for PostgreSQL, and psql is short for 'PostgreSQL SQL
> Monitor'.
>
>> ... and don't forget (maybe oddest of all) libpq! :-)
>
> libpq originally supported Postgres QUEL:
>
> http://en.wikipedia.org/wiki/QUEL_query_languages
>

Good to know all this... it might be worth adding it to the website or
the wiki for the benefit of us blow-ins. :-)

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie

Bruce Momjian

unread,
Sep 2, 2012, 8:42:24 AM9/2/12
to
On Fri, May 25, 2012 at 09:49:18AM +0100, Raymond O'Donnell wrote:
> On 25/05/2012 02:21, Bruce Momjian wrote:
> > On Wed, May 16, 2012 at 10:08:03AM +0100, Raymond O'Donnell wrote:
> >> On 15/05/2012 22:50, Scott Briggs wrote:
> >>> So this is purely anecdotal but I'm curious, what's with all the
> >>> different naming conventions? There's psql (for database
> >>> connections), pgsql (used for some dirs like /usr/pgsql-9.1 and this
> >>> mailing list), postgres (user and other references), and postgresql
> >>> (startup scripts).
> >
> > Uh, the original Berkeley project name was postgres, pgsql is used as a
> > short-hand for PostgreSQL, and psql is short for 'PostgreSQL SQL
> > Monitor'.
> >
> >> ... and don't forget (maybe oddest of all) libpq! :-)
> >
> > libpq originally supported Postgres QUEL:
> >
> > http://en.wikipedia.org/wiki/QUEL_query_languages
> >
>
> Good to know all this... it might be worth adding it to the website or
> the wiki for the benefit of us blow-ins. :-)

Added a small mention to our docs in the history section that libpq is
named after POSTQUEL. Applied patch attached.
quel.diff
0 new messages