Results 1 to 1 of 1
  1. #1
    Join Date
    Dec 2012
    Posts
    1

    Transporse in psql

    0 down vote favorite


    I have a Postgresql function in which gives me the following o/p :
    Code:
                  Sl.no    username     Designation     salary   etc..
                     1           A               XYZ            10000    ....
                     2           B               RTS            50000    .....
                     3           C              QWE            20000    ....
                     4           D              HGD            34343    ...
    Now I want the Output as below :
    Code:
             Sl.no                       1       2        3     4       .....
            Username               A       B        C     D      ...
            Designation            XYZ     RTS      QWE    HGD     ....
           Salary                 10000   50000    20000   34343   .......

    plz help..how to transporse this ..
    Last edited by loquin; 01-30-13 at 19:03. Reason: add CODE tags so as to keep tab/spacing

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •