pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedi want small information regarding postgres
8+ messages / 7 participants
[nested] [flat]
* i want small information regarding postgres
@ 2012-01-02 04:21 vinodh chowdary <vinodchowdary9@gmail.com>
0 siblings, 3 replies; 8+ messages in thread
From: vinodh chowdary @ 2012-01-02 04:21 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: i want small information regarding postgres
@ 2012-01-02 08:00 Andreas Kretschmer <akretschmer@spamfence.net>
parent: vinodh chowdary <vinodchowdary9@gmail.com>
2 siblings, 1 reply; 8+ messages in thread
From: Andreas Kretschmer @ 2012-01-02 08:00 UTC (permalink / raw)
To: pgsql-sql
vinodh chowdary <vinodchowdary9@gmail.com> 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°
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: i want small information regarding postgres
@ 2012-01-02 08:07 Erdinc Akkaya <hz.root@gmail.com>
parent: vinodh chowdary <vinodchowdary9@gmail.com>
2 siblings, 0 replies; 8+ messages in thread
From: Erdinc Akkaya @ 2012-01-02 08:07 UTC (permalink / raw)
To: vinodh chowdary <vinodchowdary9@gmail.com>; +Cc: pgsql-sql
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 <vinodchowdary9@gmail.com>
> 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
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: i want small information regarding postgres
@ 2012-01-02 10:36 Samuel Gendler <sgendler@ideasculptor.com>
parent: vinodh chowdary <vinodchowdary9@gmail.com>
2 siblings, 1 reply; 8+ messages in thread
From: Samuel Gendler @ 2012-01-02 10:36 UTC (permalink / raw)
To: vinodh chowdary <vinodchowdary9@gmail.com>; +Cc: pgsql-sql
On Sun, Jan 1, 2012 at 8:21 PM, vinodh chowdary <vinodchowdary9@gmail.com>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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Fwd: i want small information regarding postgres
@ 2012-01-02 11:44 Samuel Gendler <sgendler@ideasculptor.com>
parent: Samuel Gendler <sgendler@ideasculptor.com>
0 siblings, 1 reply; 8+ messages in thread
From: Samuel Gendler @ 2012-01-02 11:44 UTC (permalink / raw)
To: pgsql-sql
would someone with the appropriate authority please unsubscribe this
person's email address from this list so we don't all get a bounce message
after every email we send to the list? Thanks.
--sam
---------- Forwarded message ----------
From: Jan Verheyden <jan.verheyden@uz.kuleuven.ac.be>
Date: 2012/1/2
Subject: Re: [SQL] i want small information regarding postgres
Please find an English version below.
--------------------
Geachte,
Dit is een geautomatiseerd antwoord.
Het email adres van Jan Verheyden werkt niet meer.
De gebruiker heeft geen email adres opgegeven voor professionele doeleinden.
De gebruiker heeft geen email adres opgegeven voor persoonlijke doeleinden.
Gelieve niet te antwoorden op deze geautomatiseerde email.
Hoogachtend,
Dienst Informatiesystemen
Systeembeheer en Ondersteuning
UZ Leuven
--------------------
Dear,
This is an automated reply.
The email address of Jan Verheyden is no longer active.
The user has not indicated an email address for professional purposes.
The user has not indicated an email address for personal purposes.
Please do not reply to this automated email.
Kind regards,
Information Technology
System Administration and Support
UZ Leuven
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: i want small information regarding postgres
@ 2012-01-02 19:13 Brent Dombrowski <brent.dombrowski@gmail.com>
parent: Andreas Kretschmer <akretschmer@spamfence.net>
0 siblings, 0 replies; 8+ messages in thread
From: Brent Dombrowski @ 2012-01-02 19:13 UTC (permalink / raw)
To: pgsql-sql
On Jan 2, 2012, at 12:00 AM, Andreas Kretschmer wrote:
> vinodh chowdary <vinodchowdary9@gmail.com> 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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Fwd: i want small information regarding postgres
@ 2012-01-05 17:52 Alvaro Herrera <alvherre@commandprompt.com>
parent: Samuel Gendler <sgendler@ideasculptor.com>
0 siblings, 1 reply; 8+ messages in thread
From: Alvaro Herrera @ 2012-01-05 17:52 UTC (permalink / raw)
To: Samuel Gendler <sgendler@ideasculptor.com>; +Cc: pgsql-sql
Excerpts from Samuel Gendler's message of lun ene 02 08:44:53 -0300 2012:
> would someone with the appropriate authority please unsubscribe this
> person's email address from this list so we don't all get a bounce message
> after every email we send to the list? Thanks.
Just did it. In the future, please email sysadmins@postgresql.org with
mailing list complaints, as I don't read this list (or indeed many
others)
--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Fwd: i want small information regarding postgres
@ 2012-01-10 17:01 Tim Landscheidt <tim@tim-landscheidt.de>
parent: Alvaro Herrera <alvherre@commandprompt.com>
0 siblings, 0 replies; 8+ messages in thread
From: Tim Landscheidt @ 2012-01-10 17:01 UTC (permalink / raw)
To: pgsql-sql
Alvaro Herrera <alvherre@commandprompt.com> wrote:
>> would someone with the appropriate authority please unsubscribe this
>> person's email address from this list so we don't all get a bounce message
>> after every email we send to the list? Thanks.
> Just did it. In the future, please email sysadmins@postgresql.org with
> mailing list complaints, as I don't read this list (or indeed many
> others)
I had reported this to pgsql-sql-owner@postgresql.org.
Where do that end up?
Tim
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2012-01-10 17:01 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-01-02 04:21 i want small information regarding postgres vinodh chowdary <vinodchowdary9@gmail.com>
2012-01-02 08:00 ` Andreas Kretschmer <akretschmer@spamfence.net>
2012-01-02 19:13 ` Brent Dombrowski <brent.dombrowski@gmail.com>
2012-01-02 08:07 ` Erdinc Akkaya <hz.root@gmail.com>
2012-01-02 10:36 ` Samuel Gendler <sgendler@ideasculptor.com>
2012-01-02 11:44 ` Samuel Gendler <sgendler@ideasculptor.com>
2012-01-05 17:52 ` Alvaro Herrera <alvherre@commandprompt.com>
2012-01-10 17:01 ` Tim Landscheidt <tim@tim-landscheidt.de>
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