Naming conventions

Started by Scott Briggsalmost 14 years ago5 messagesgeneral
Jump to latest
#1Scott Briggs
scott.br@gmail.com

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

In reply to: Scott Briggs (#1)
Re: Naming conventions

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
rod@iol.ie

#3Bruce Momjian
bruce@momjian.us
In reply to: Raymond O'Donnell (#2)
Re: Naming conventions

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 <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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

In reply to: Bruce Momjian (#3)
Re: Naming conventions

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
rod@iol.ie

#5Bruce Momjian
bruce@momjian.us
In reply to: Raymond O'Donnell (#4)
Re: Naming conventions

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.

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

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

Attachments:

quel.difftext/x-diff; charset=us-asciiDownload+4-4