export query from table column to text file

[aypa genga]

I want to export a single column of a table to a text file. How can i do it with a sql query.
Please help

[Campbell Ritchie]

Use a simple select statement, then write the results to the text file with a FileWriter or Formatter.

[avani vakharwala]

 import java.sql.*;
import java.io.*;

public class filejebc {

	/**
	 * @param args
	 */
	public static void main(String[] args) {

	try {
		Connection cn=null;
		Class.forName("org.postgresql.Driver");
		String url="jdbc:postgresql:postgres";
		String user="postgres" ;
		String password="Welcome123";
			
			
				cn=DriverManager.getConnection(url, user, password);
				Statement st = cn.createStatement();
			      ResultSet res = st.executeQuery("SELECT * FROM  emp");
			      System.out.println("Employee Name: " );
			      File f=new File("output.txt");
			        FileOutputStream fp=new FileOutputStream(f);
			        
			      while (res.next()) {
			        String employeeName = res.getString("empname");
			        fp.write(employeeName.getBytes());
			       String newline="\r\n";
			        fp.write(newline.getBytes()); 
			        System.out.println(employeeName);
			      }
			      fp.flush();
			        fp.close();
			        
		     	      cn.close();
	} catch (FileNotFoundException e) {
		
		e.printStackTrace();
	} catch (ClassNotFoundException e) {
	
		e.printStackTrace();
	} catch (SQLException e) {
		
		e.printStackTrace();
	} catch (IOException e) {
	
		e.printStackTrace();
	}

		
	}

}   

[Campbell Ritchie]

avani vakharwala welcome to JavaRanch

And thank you.