Re: [SQL] i want small information regarding postgres

2012-01-02 Thread Andreas Kretschmer
vinodh chowdary wrote: > Hi sir, > > i am using postgres as database for my project. > i want to convert postgres data into excel sheet. > is there any way to do it? > please reply me. This should be possible with ODBC. (But i'm not familiar with it, don't ask me how ...) Andreas -- Really

Re: [SQL] i want small information regarding postgres

2012-01-02 Thread Erdinc Akkaya
use copy command. COPY (your_sql_goes_here) TO '/home/someone/test.csv'; you can also set delimeter. take a look at http://www.postgresql.org/docs/current/static/sql-copy.html 2012/1/2 vinodh chowdary > Hi sir, > > i am using postgres as database for my project. > i want to convert postgres d

Re: [SQL] i want small information regarding postgres

2012-01-02 Thread Samuel Gendler
On Sun, Jan 1, 2012 at 8:21 PM, vinodh chowdary wrote: > Hi sir, > > i am using postgres as database for my project. > i want to convert postgres data into excel sheet. > is there any way to do it? > please reply me. > > You can export data in CSV format, which excel can easily read, or you can s

Re: [SQL] i want small information regarding postgres

2012-01-02 Thread Brent Dombrowski
On Jan 2, 2012, at 12:00 AM, Andreas Kretschmer wrote: > vinodh chowdary wrote: > >> Hi sir, >> >> i am using postgres as database for my project. >> i want to convert postgres data into excel sheet. >> is there any way to do it? >> please reply me. > > This should be possible with ODBC. > (

Re: [SQL] new user on mac

2012-01-02 Thread Guillaume Lelarge
On Thu, 2011-10-20 at 04:15 -0700, Scott Swank wrote: > Here is a seeming quirk in pgadmin3. I say seeming, because I may > simply not be sufficiently familiar with this tool. > > [A quick note for non-mac users, the Finder is the gui file browser, > equivalent to Nautilus/Dolphin in linux or the