Re: Ascii Elephant for text based protocols

Hello Melvin

Thank you for your code.

With the current design (not yet necessarily the final one):

CREATE TABLE elephant
(row_num integer NOT NULL,
  row_dat varchar(30) NOT NULL,
  CONSTRAINT elephant_pk PRIMARY KEY (row_num)
);

INSERT INTO elephant
(row_num, row_dat)
VALUES
( 1,'+------------------------+'),
( 2,'|   ____  ______  ___    |'),
( 3,'|  /    )/      \/   \   |'),
( 4,'| (     / __    _\    )  |'),
( 5,'|  \    (/ o)  ( o)   )  |'),
( 6,'|   \_  (_  )   \ ) _/   |'),
( 7,'|     \  /\_/    \)/     |'),
( 8,'|      \/ <//|  |\\>     |'),
( 9,'|            |  |        |'),
(10,'|            |/\|        |'),
(11,'|                        |'),
(12,'|  PostgreSQL 1996-2016  |'),
(13,'|  20 Years of success   |'),
(14,'+------------------------+');

SELECT row_dat FROM elephant ORDER BY row_num;

Bye
Charles

On 05/16/2016 05:56 AM, Melvin Davidson wrote:
> To all, thanks for the concept. The following based on original  design
> submission, might help in tweaking:
>
> CREATE TABLE elephant
> (row_num integer NOT NULL,
>   row_dat varchar(30) NOT NULL,
>   CONSTRAINT elephant_pk PRIMARY KEY (row_num)
> );
>
> INSERT INTO elephant
> (row_num, row_dat)
> VALUES
> ( 1,'+------------------------+'),
> ( 2,'|   ____  ______  ___    |'),
> ( 3,'|  /    )/      \/   \   |'),
> ( 4,'| (     / __    _\    )  |'),
> ( 5,'|  \    (/ o)  ( o)   )  |'),
> ( 6,'|   \_  (_  )   \ )  /   |'),
> ( 7,'|     \  /\_/    \)_/    |'),
> ( 8,'|      \/  //|  |\\      |'),
> ( 9,'|          v |  | v      |'),
> (10,'|            \__/        |'),
> (11,'|                        |'),
> (12,'|  PostgreSQL 1996-2016  |'),
> (13,'|  20 Years of success   |'),
> (14,'+------------------------+');
>
> SELECT row_dat FROM elephant ORDER BY row_num;
>
>
> --
> *Melvin Davidson*
> I reserve the right to fantasize.  Whether or not you
> wish to share my fantasy is entirely up to you.

--
Swiss PostgreSQL Users Group
c/o Charles Clavadetscher
Motorenstrasse 18
CH - 8005 Zürich

http://www.swisspug.org