• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

export query from table column to text file

 
aypa genga
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Pie
Posts: 49367
62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use a simple select statement, then write the results to the text file with a FileWriter or Formatter.
 
avani vakharwala
Greenhorn
Posts: 6
Eclipse IDE Hibernate Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
 
Campbell Ritchie
Sheriff
Pie
Posts: 49367
62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
avani vakharwala welcome to JavaRanch

And thank you.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic