pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Other list - or answer? 2+ messages / 2 participants [nested] [flat]
* Other list - or answer? @ 2007-07-05 17:53 Carol Walter <walterc@indiana.edu> 2007-07-05 18:04 ` Re: Other list - or answer? Joshua D. Drake <jd@commandprompt.com> 0 siblings, 1 reply; 2+ messages in thread From: Carol Walter @ 2007-07-05 17:53 UTC (permalink / raw) To: pgsql-admin Hello, My supervisor has requested that I copy a small database to Excel for her to look at. The first time I did it, I used the copy command and the data was so dirty that it didn't come in very well. Someone suggested that I use a pipe to delimit the data so that the Excel can ignore the commas that are imbedded in the data. I tried to do that and I'm having trouble with the syntax. Is there another list where I should bring this kind of query question? I have already searched for an answer on the postgres.org site, but didn't turn up anything useful for this. Thanks, Carol ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Other list - or answer? 2007-07-05 17:53 Other list - or answer? Carol Walter <walterc@indiana.edu> @ 2007-07-05 18:04 ` Joshua D. Drake <jd@commandprompt.com> 0 siblings, 0 replies; 2+ messages in thread From: Joshua D. Drake @ 2007-07-05 18:04 UTC (permalink / raw) To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin Carol Walter wrote: > Hello, > > My supervisor has requested that I copy a small database to Excel for > her to look at. The first time I did it, I used the copy command and > the data was so dirty that it didn't come in very well. Someone > suggested that I use a pipe to delimit the data so that the Excel can > ignore the commas that are imbedded in the data. I tried to do that and > I'm having trouble with the syntax. > > Is there another list where I should bring this kind of query question? > I have already searched for an answer on the postgres.org site, but > didn't turn up anything useful for this. I would use Access, but if you have to use Excel, make sure you do it via ODBC so you don't have to clean up the data. J > > Thanks, > Carol > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-07-05 18:04 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2007-07-05 17:53 Other list - or answer? Carol Walter <walterc@indiana.edu> 2007-07-05 18:04 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox