Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iuDkj-0004Q4-It for pgsql-admin@arkaria.postgresql.org; Wed, 22 Jan 2020 11:00:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iuDkh-0004XJ-Ih for pgsql-admin@arkaria.postgresql.org; Wed, 22 Jan 2020 11:00:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iuDkh-0004XB-6B for pgsql-admin@lists.postgresql.org; Wed, 22 Jan 2020 11:00:51 +0000 Received: from f4mail-235-235.rediffmail.com ([202.137.235.235] helo=rediffmail.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iuDke-0006Sl-Oh for pgsql-admin@postgresql.org; Wed, 22 Jan 2020 11:00:50 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=rediffmail.com; s=mail; t=1579690845; bh=QTiTMB7HArACj4wtlyoLkqe9nFekl/hOcCj2aeLrt7Y=; h=MIME-Version:From:Date:Message-ID:Subject:To:Content-Type; b=kzcbAor8BZi7O5egNHHkZtgtt3t+bfpZIr0msdr+Bw2It/J7pC1Avbx9PROYOYeZS oO1vJbhNDf/1rchyDS+GEXayJyJm6t0skWqW+dG/v4PitWBA9z8J/TbEjEqn6j6eLG /AoZbMlQXbWWz4K6i4KYqJtlKq4d5pGEQbDS95EU= Received: (qmail 14712 invoked by uid 510); 22 Jan 2020 11:00:45 -0000 x-m-msg: asd54ad564ad7aa6sd5as6d5; a6da7d6asas6dasd77; 5dad65ad5sd; X-OUT-VDRT-SpamState: 0\LEGIT X-OUT-VDRT-SpamScore: 0 X-OUT-VDRT-SpamCause: gggruggvucftvghtrhhoucdtuddrgedugedrvddtgddvtdcutefuodetggdotefrodftvfcurfhrohhfihhlvgemucdftffgfffkhffhpdfqfgfvfdenuceurghilhhouhhtmecufedttdenucenucfjughrpeffkfggvfhsuffhtgesrgdtvdertddtjeenucfhrhhomhepfdhsrhhikhhkrghnthhhfdcuoehsrhhikhhkrghnthhhudeitdekudelledusehrvgguihhffhhmrghilhdrtghomheqnecukfhppedugedrudegtddrudekiedrudegnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmohguvgepshhmthhpohhuth X-Remote-IP: 14.140.186.14 X-REDF-OSEN: srikkanth16081991@rediffmail.com Date: 22 Jan 2020 11:00:45 -0000 Message-ID: <20200122110045.14705.qmail@f4mail-235-235.rediffmail.com> MIME-Version: 1.0 To: , Received: from unknown 14.140.186.14 by rediffmail.com via HTTP; 22 Jan 2020 11:00:45 -0000 X-Senderscore: D=0&S=0 Sender: srikkanth16081991@rediffmail.com Subject: =?utf-8?B?U1FMIFF1ZXJ5IFN5bnRheCBoZWxwIA==?= From: "srikkanth" Content-Type: multipart/alternative; boundary="=_5e7cc60a00720aaf4e79d619f8327119" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --=_5e7cc60a00720aaf4e79d619f8327119 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="UTF-8" Hi Team,Can you please help me in writing the syntax for the below mentioned table.Input :  ID Col A Col B Col C Col D Col E Col F 1111 aaaa bbbb cccc dddd eeee ffff 2222 bbbb cccc dddd eeee ffff aaaa 3333 cccc dddd eeee ffff aaaa bbbb 4444 dddd eeee ffff aaaa bbbb cccc 5555 eeee ffff aaaa bbbb cccc dddd 6666 ffff aaaa bbbb cccc dddd eeee 7777 cccc dddd eeee ffff aaaa bbbb 8888 dddd eeee ffff aaaa bbbb cccc 9999 ffff aaaa bbbb cccc dddd eeee  Required Output : ID Col Name Col Value 1111 Col A aaaa 1111 Col B bbbb 1111 Col C cccc 1111 Col D dddd 1111 Col E eeee 1111 Col F ffff 2222 Col A bbbb 2222 Col B cccc 2222 Col C dddd 2222 Col D eeee 2222 Col E ffff 2222 Col F aaaa 3333 Col A cccc 3333 Col B dddd 3333 Col C eeee 3333 Col D ffff 3333 Col E aaaa 3333 Col F bbbb And so on for the 4444, 5555, 6666, 7777, 8888, 9999Thanks,Srikanth B --=_5e7cc60a00720aaf4e79d619f8327119 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="UTF-8" Hi Team,

Can you please help me in writing the syntax for the be= low mentioned table.

Input : Col D = = = <= /tr> <= td nowrap=3D"nowrap" style=3D"width:39px;border-top:none;border-left:none;b= order-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5= .4pt 0in 5.4pt;height:20px;vertical-align:bottom;">bbbb <= td nowrap=3D"nowrap" style=3D"width:39px;border-top:none;border-left:none;b= order-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5= .4pt 0in 5.4pt;height:20px;vertical-align:bottom;">eeee9999
ID Col A Col B Col C Col = E Col F
1111 = aaaa bbbb cccc = dddd eeee ffff
2222bbbb cccc ddddeeee ffff aaaa
3333 cccc dddd eeee ffff aaaa bbbb
4444 dddd eeee ffff aaaa bbbb cccc
5= 555 eeee ffff a= aaa bbbb cccc d= ddd
6666 ffff aaaa cccc dddd
7777 cccc dddd eeee ffff aaaa bbbb
8888 dddd eeee ffff aaaa bbbb cccc
ffff a= aaa bbbb cccc d= ddd eeee
 
Required Output : = 2222 = = <= td nowrap=3D"nowrap" style=3D"width:64px;border-top:none;border-left:none;b= order-bottom:solid black 1.0pt;border-right:solid black 1.0pt;padding:0in 5= .4pt 0in 5.4pt;height:20px;vertical-align:bottom;">aaaa =
ID Col Name Col Value
1111 Col A aaaa
1111 = Col B bbbb
1111 Col Ccccc
1111 Col D dddd=
1111 Col E eeee
1111 Col F ffff
2222 Col A bbbb
Col B = cccc
2222 Col C dddd
2222<= /td> Col D eeee
2222 Col= E ffff
= 2222 Col F
3333 Col A cccc
3333 Col B dddd
3333 = Col C eeee
3333 Col Dffff
3333 Col E aaaa=
3333 Col F bbbb

And so on for= the 4444, 5555, 6666, 7777, 8888, 9999

Thanks,
Srikanth B
--=_5e7cc60a00720aaf4e79d619f8327119--