Re: [SQL] i want small information regarding postgres
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, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknown) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] i want small information regarding postgres
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 data into excel sheet. > is there any way to do it? > please reply me. > > > > > -- > vinodh > >
Re: [SQL] i want small information regarding postgres
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 set up ODBC access and load data directly into excel via an odbc query. Google "postgresql csv" for the first solution and "postgresql excel odbc" for the second. In both cases, the very first link has exactly the information you are looking for.
Re: [SQL] i want small information regarding postgres
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. > (But i'm not familiar with it, don't ask me how ...) I've used ODBC to generate Excel reports from PostgreSQL data in the past. It's fairly easy for simple queries. If your queries are complicated, you may have to execute them from a Visual Basic Macro. The MS query builder will try to check raw SQL and may reject your query because it's not that smart. In particular, I had trouble with stored procedures in my queries. If it is something that you plan on doing routinely, I would set up a macro and a keyboard shortcut or button so you can run the macro quickly and easily. -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] new user on mac
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 Window Explorer in MS > Windows.] > > I have associated sql files with pgadmin. > > When I open pgadmin I have a "pgadmin" window and I can open > additional "query tool" windows. However, if from the finder I open a > sql file I do not see it in a query tool window. Application focus > changes from the finder to pgadmin, but I do not see the sql. > > Conversely, if I do not have pgadmin open and from the finder I open a > sql file I see it in a query tool window. I, however, I open > additional sql files from the finder they do not open in a query tool > window, but again focus changes to pgadmin. Also, if I start pgadmin > this way I only have query tool windows, how do I open the basic > pgadmin window? > > This behavior does not seem to depend on how I open the file, e.g. > double-click, or "open with: pgadmin3". > > Is this simply an os integration issue on mac, or am I missing something? > Seems to be an integration issue. I created a ticket to work on this later. Sorry for the (really really) late answer. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3: http://www.postgresql-sessions.org -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
