Enclosed by " while generating a file from a table

[rajasekhart]

Hi,

I want enclose the data within double quotes (") ,While i am generating a file from a table.

Eg: Create table Employee(Emp_Id int, Emp_Name varchar(80) )

Insert into Employee
select 1, 'Raj' union all
select 2, 'Smith' union all
select 3, 'Rose';

select * from Employee;
Emp_Id Emp_Name

1 Raj
2 Smith
3 Rose


Now i want to generate a file to this table , and i want the data in the file enclosed by double quote (") as follows.

Raj=> \o /home/dbadmin/Employee --file name Employee
Raj=> select * from Employee

Emp_ID Emp_Name
"1" "Raj"
"2" "Smith"
"3" "Rose"

Please help me

Thanks in advance ,
Raj

[id10t]

Hi Raj

Code: Select all

%> vsql -c "select * from encloseExample;"
  a  | b |  c  
-----+---+-----
 111 | b | baz
 333 | d | egg
 666 | a | foo
 999 | c | bar
(4 rows)

Code: Select all

%> vsql -At -F '" "' -c "select * from encloseExample;" | sed -e 's/^\|$/"/g'
"111" "b" "baz"
"333" "d" "egg"
"666" "a" "foo"
"999" "c" "bar"