Postgres Pro
Downloads
Home   >   mailing lists

Thread: i want small information regarding postgres

i want small information regarding postgres

From
vinodh chowdary
Date:
Hi sir,<br /><br />i am using postgres as database for  my project.<br />i want to convert postgres data into excel
sheet.<br/>is there any way to do it?<br />please reply me.<br /><br /><br /><br clear="all" /><br />-- <br />vinodh<br
/><br/>

Re: i want small information regarding postgres

From
Andreas Kretschmer
Date:
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°

Re: i want small information regarding postgres

From
Erdinc Akkaya
Date:
use copy command.
COPY (your_sql_goes_here) TO '/home/someone/test.csv';

you can also set delimeter. take a look at 


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


Re: i want small information regarding postgres

From
Samuel Gendler
Date:


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.

Re: i want small information regarding postgres

From
Brent Dombrowski
Date:
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
queriesare complicated, you may have to execute them from a Visual Basic Macro. The MS query builder will try to check
rawSQL 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
soyou can run the macro quickly and easily.

Fwd: i want small information regarding postgres

From
Samuel Gendler
Date:
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

Re: Fwd: i want small information regarding postgres

From
Alvaro Herrera
Date:
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

Re: Fwd: i want small information regarding postgres

From
Tim Landscheidt
Date:
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