PostgreSQL reference coffee mug

po 26. 7. 2021 v 8:56 odesílatel Matthias Apitz <guru@unixarea.de> napsal:

Hello,

Nearly 20 years ago, I ordered some 50 vi-reference coffee mugs like this
one here (not exactly the same, but to give you an idea):

https://www.getdigital.eu/vi-reference-mug.html

for our vi-lovers in-house and the admins of our customers.

I'd like to do the same now with a reference mug for PostgreSQL, for
example with the most important Meta-commands, sys tables, etc.
I have nearby a copy shop which would produce it based on a JPEG file.

Before designing our own, I wanted to ask here if such a beast exists
already or, if not, maybe even a Reference Card in PDF or JPEG to use it
as a
starting point.

Thanks in advance for any hints.

I have this in czech language - maybe google translator
https://translate.google.com/ helps

https://postgres.cz/files/tahak_postgresql-13.pdf

Regards

Pavel

On Jul 26, 2021, at 1:06 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:



Thanks in advance for any hints.

I have this in czech language - maybe google translator https://translate.google.com/ helps

https://postgres.cz/files/tahak_postgresql-13.pdf

Regards

Pavel

I could definitely use a mug large enough to hold all that.

po 26. 7. 2021 v 13:44 odesílatel Rob Sargent <robjsargent@gmail.com>
napsal:

On Jul 26, 2021, at 1:06 AM, Pavel Stehule <pavel.stehule@gmail.com>
wrote:



Thanks in advance for any hints.

I have this in czech language - maybe google translator
https://translate.google.com/ helps

https://postgres.cz/files/tahak_postgresql-13.pdf

Regards

Pavel

I could definitely use a mug large enough to hold all that. \

:-)

El día lunes, julio 26, 2021 a las 09:05:39a. m. +0200, Pavel Stehule escribió:

po 26. 7. 2021 v 8:56 odesílatel Matthias Apitz <guru@unixarea.de> napsal:

Hello,

Nearly 20 years ago, I ordered some 50 vi-reference coffee mugs like this
one here (not exactly the same, but to give you an idea):

https://www.getdigital.eu/vi-reference-mug.html

for our vi-lovers in-house and the admins of our customers.

I'd like to do the same now with a reference mug for PostgreSQL, for
example with the most important Meta-commands, sys tables, etc.
I have nearby a copy shop which would produce it based on a JPEG file.

Before designing our own, I wanted to ask here if such a beast exists
already or, if not, maybe even a Reference Card in PDF or JPEG to use it
as a
starting point.

Thanks in advance for any hints.

I have this in czech language - maybe google translator
https://translate.google.com/ helps

https://postgres.cz/files/tahak_postgresql-13.pdf

Thank you, Pavel. This is ofc to much for a coffee mug. For using it as
a Reference Card in paper form, it's a pity that it is not written in English.

I'm working on my own for the mug and will publish the PDF and
libreoffice ODT version here. The max size of the image for the mug is
7.5cm high x 16cm around the body of the coffee mug.

A question to PostgreSQL.org: Are we allowed to use the PostgreSQL logo
on such produced mugs without selling them, just as a gift.
And can we put our own logo together with the one of PostgreSQL on the
same coffee mug.

To whom our Legal Dept. would have to ask this officially? Or is it just
free and allowed?

Thanks

matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Tear it down! Defund the Humboldt Forum!
https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html

On 27 Jul 2021, at 20:32, Matthias Apitz <guru@unixarea.de> wrote:

A question to PostgreSQL.org: Are we allowed to use the PostgreSQL logo
on such produced mugs without selling them, just as a gift.
And can we put our own logo together with the one of PostgreSQL on the
same coffee mug.

To whom our Legal Dept. would have to ask this officially? Or is it just
free and allowed?

Use of the PostgreSQL logo falls under the project Trademark Policy, which you
can find here:

https://www.postgresql.org/about/policies/trademarks/

There is a point of contact listed there as well in case there are more
detailed questions.

--
Daniel Gustafsson https://vmware.com/

El día martes, julio 27, 2021 a las 08:32:45p. m. +0200, Matthias Apitz escribió:

Thank you, Pavel. This is ofc to much for a coffee mug. For using it as
a Reference Card in paper form, it's a pity that it is not written in English.

I'm working on my own for the mug and will publish the PDF and
libreoffice ODT version here. The max size of the image for the mug is
7.5cm high x 16cm around the body of the coffee mug.

Attached is a first version as PDF. Bugs/comments are welcome. Thanks.

matthias

--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Tear it down! Defund the Humboldt Forum!
https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html

Hello Matthias,

Am 28.07.2021 um 15:40 schrieb Matthias Apitz:

El día martes, julio 27, 2021 a las 08:32:45p. m. +0200, Matthias Apitz escribió:

Thank you, Pavel. This is ofc to much for a coffee mug. For using it as
a Reference Card in paper form, it's a pity that it is not written in English.

I'm working on my own for the mug and will publish the PDF and
libreoffice ODT version here. The max size of the image for the mug is
7.5cm high x 16cm around the body of the coffee mug.

only typos:

\o file snnds  -> sends

\passwor  -> password

createdb ... dbna -> dbname

Attached is a first version as PDF. Bugs/comments are welcome. Thanks.

matthias

regards

Georg

On 7/28/21 8:01 AM, Georg H. wrote:

Hello Matthias,

Am 28.07.2021 um 15:40 schrieb Matthias Apitz:

El día martes, julio 27, 2021 a las 08:32:45p. m. +0200, Matthias
Apitz escribió:

Thank you, Pavel. This is ofc to much for a coffee mug. For using it as
a Reference Card in paper form, it's a pity that it is not written in
English.

I'm working on my own for the mug and will publish the PDF and
libreoffice ODT version here. The max size of the image for the mug is
7.5cm high x 16cm around the body of the coffee mug.

only typos:

\o file snnds  -> sends

\passwor  -> password

createdb ... dbna -> dbname

To add to above:

\set \s allone -> alone

Attached is a first version as PDF. Bugs/comments are welcome. Thanks.

    matthias

regards

Georg

--
Adrian Klaver
adrian.klaver@aklaver.com

On 2021-Jul-28, Adrian Klaver wrote:

On 7/28/21 8:01 AM, Georg H. wrote:

To add to above:

\set \s allone -> alone

Actually that's wrong, because \s prints history not variables. This
needs to read
\set alone ...

I'm *not* going to get into this, because I know I'm capable of spending
days on it. I would definitely look into using different font sizes and
colors and make it much denser, for one thing.

--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/

Thanks to all hints about typos and bug. Attached is a corrected version
as PDF.

El día miércoles, julio 28, 2021 a las 11:38:22a. m. -0400, Alvaro Herrera escribió:

I'm *not* going to get into this, because I know I'm capable of spending
days on it. I would definitely look into using different font sizes and
colors and make it much denser, for one thing.

I'm attaching as well the source for libreoffice calc, so you are free
to make a nicer version. Do not forget the final size in PDF as
7.5cm x 16cm.

Thanks

matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Tear it down! Defund the Humboldt Forum!
https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html

El día miércoles, julio 28, 2021 a las 06:58:08p. m. +0200, Matthias Apitz escribió:

I'm *not* going to get into this, because I know I'm capable of spending
days on it. I would definitely look into using different font sizes and
colors and make it much denser, for one thing.

I'm attaching as well the source for libreoffice calc, so you are free
to make a nicer version. Do not forget the final size in PDF as
7.5cm x 16cm.

I printed the PDF on paper, cut it to the size of 7.5cm x 16cm and
wrapped it around the mugs I have here. 16cm is not correct. My mugs have
more or less 7-8cm as diameter which gives around:

$ bc -l

7.5 * pi(2)

23.550

I will go tomorrow to the copy shop and ask/measure it there...
Which means also, we have more space for more information.

matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Tear it down! Defund the Humboldt Forum!
https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html

Matthias Apitz said on Wed, 28 Jul 2021 15:40:22 +0200

El día martes, julio 27, 2021 a las 08:32:45p. m. +0200, Matthias
Apitz escribió:

Thank you, Pavel. This is ofc to much for a coffee mug. For using it
as a Reference Card in paper form, it's a pity that it is not
written in English.

I'm working on my own for the mug and will publish the PDF and
libreoffice ODT version here. The max size of the image for the mug
is 7.5cm high x 16cm around the body of the coffee mug.

Attached is a first version as PDF. Bugs/comments are welcome. Thanks.

matthias

Very, very nice! I'll be using this quite a bit.

Does there exist anywhere a Reference Card for PostgreSQL SQL commands?
My impression is that every database has its own slightly different
version of SQL that it responds to.

Thanks,

SteveT

Steve Litt
Spring 2021 featured book: Troubleshooting Techniques of the Successful
Technologist http://www.troubleshooters.com/techniques

El día miércoles, julio 28, 2021 a las 07:30:24p. m. +0200, Matthias Apitz escribió:

I printed the PDF on paper, cut it to the size of 7.5cm x 16cm and
wrapped it around the mugs I have here. 16cm is not correct. My mugs have
more or less 7-8cm as diameter which gives around:

$ bc -l

7.5 * pi(2)

23.550

I will go tomorrow to the copy shop and ask/measure it there...
Which means also, we have more space for more information.

Resulted, that the size can be 20.12cm X 7.5cm. Attached is an updated
version as PDF. Hints/bugs are welcome.

matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Tear it down! Defund the Humboldt Forum!
https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html

On 29/07/21, Matthias Apitz (guru@unixarea.de) wrote:

El d�a mi�rcoles, julio 28, 2021 a las 07:30:24p. m. +0200, Matthias Apitz escribi�:

Resulted, that the size can be 20.12cm X 7.5cm. Attached is an updated
version as PDF. Hints/bugs are welcome.

I personally find that, after \l (list databases), connecting to a different
one with \c is pretty useful.

\? : to list help subjects
\? options
\? variables
\h

\watch [SEC] : is helpful, for example for keeping an eye on connections via pg_stat_activity

\e | \ef | \ev : is incredibly helpful if you are working on a query, function or view which you immediately want to load into the database via the query buffer (setting the EDITOR env will help). Best done in production, of course.

\set ON_ERROR_STOP on : to abort on first error

\timing on : very helpful to see how fast or slowly your function or query runs

Perhaps some example pg_stat_activity calls might be worth list, eg:

SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
# https://gist.github.com/rgreenjr/3637525

Rory

The prototype is ready.

matthias

--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Tear it down! Defund the Humboldt Forum!
https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html

I suggest a series: one per chapter!

On 8/6/21 11:09 AM, Matthias Apitz wrote:

The prototype is ready.

+1

matthias

--
Adrian Klaver
adrian.klaver@aklaver.com

Am Fri, Aug 06, 2021 at 08:09:03PM +0200 schrieb Matthias Apitz:

The prototype is ready.

Nice. Now the elephant needs to fade into the background.

Karsten
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

El día sábado, agosto 07, 2021 a las 08:06:14p. m. +0200, Karsten Hilbert escribió:

Am Fri, Aug 06, 2021 at 08:09:03PM +0200 schrieb Matthias Apitz:

The prototype is ready.

Nice. Now the elephant needs to fade into the background.

It is already in the background (done with libreoffice calc). See the
attached PDF. Only the black lines of the Elephant logo are a problem.
Don't know how to solve this.

matthias
--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
Tear it down! Defund the Humboldt Forum!
https://www.jungewelt.de/artikel/406715.humboldt-forum-feudaler-themenpark.html