How to make a txt/doc/pdf/html file as we want to view in PostgreSQL

How to make a txt/doc/pdf/html file as we want to view in PostgreSQL

I have the tables and data .
What i want is, to generate a report of all the students sorted by there
names..
--student table
create table student(
sid int,
sname text
);
--student details
insert into student(sid,sname)
values(101,'John'),
(102,'barbie'),
(103,'britney'),
(104,'jackson'),
(105,'abraham')
;
--questions table all the questions for the test
create table questions(
questionid serial,
question text
);
--i have the questions in my table
insert into questions(question)
values('How much is 1+1'),('What is the value of PI'),('Whose dimensions
are all equal');
--the test table it contains the details of the test attebdee by every
student..
create table test(
sno serial,
sid int,
questionid int,
answer text,
marks int
);
--insert into test table the answers and the marks ..should be updated here..
insert into test(sid,questionid,answer,marks)
values(101,1,'2',10),
(102,2,' 3 ',0),
(103,3,' ring ',0),
(104,1,' 1 ',0),
(105,1,' 1 ',0),
(101,2,'3.7',0),
(101,3,' square',10);
My Requirement:
My txt/doc/pdf/html file which is generated should be in a view as below

live sql fiddle demo i tried