Thread: Naming conventions
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
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
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. +
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
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. +