pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedImport (.CVS File) to postgreSql
4+ messages / 3 participants
[nested] [flat]
* Import (.CVS File) to postgreSql
@ 2009-08-11 03:54 Premila Devi <premiladevi.dayalan@agbnielsen.com>
2009-08-11 05:12 ` Re: Import (.CVS File) to postgreSql A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 1 reply; 4+ messages in thread
From: Premila Devi @ 2009-08-11 03:54 UTC (permalink / raw)
To: pgsql-sql
Dear All,
I like to import (.CVS File) to postgreSql.Could anyone help me. May I know,
what the requirement.
Herewith I attach an Example of CVS File,Plese tell me how to restore in
Postgresql.
Thank you.
<http://www.agbnielsen.com/;
http://cs.agbnmr.com/ci/autocomposition/logo_agb.jpg
Warmest Regards,
Premila Devi Dayalan Ramasamy
Programmer Analyst
MSAP Production Development
AGB Nielsen Media Research
Level 7,Block B,Menara PKNS-PJ,Jalan Yong Shook Lin , 46050 Petaling Jaya ,
Selangor
( Malaysia )
t: 603-7620 2320
f: 603-7620 2316
Please note:
This email transmission including its attachments, are intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. Any views or opinions are solely those of the
author and do not necessarily represent those of AGB Nielsen Media Research,
unless specifically stated. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information by
persons or entities other than the intended recipient is prohibited. If you
received this email in error, please contact the sender and delete the email
transmission immediately.
Attachments:
image001.jpg (image/jpeg, 5.4K) download
view image
* Re: Import (.CVS File) to postgreSql
2009-08-11 03:54 Import (.CVS File) to postgreSql Premila Devi <premiladevi.dayalan@agbnielsen.com>
@ 2009-08-11 05:12 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
0 siblings, 0 replies; 4+ messages in thread
From: A. Kretschmer @ 2009-08-11 05:12 UTC (permalink / raw)
To: pgsql-sql
In response to Premila Devi :
> Dear All,
>
>
>
> I like to import (.CVS File) to postgreSql.Could anyone help me. May I know,
> what the requirement.
You can use the COPY-command for that, see the doc.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Import (.CVS File) to postgreSql
@ 2009-08-11 04:22 Shoaib Mir <shoaibmir@gmail.com>
2009-08-11 04:58 ` Re: Import (.CVS File) to postgreSql Shoaib Mir <shoaibmir@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Shoaib Mir @ 2009-08-11 04:22 UTC (permalink / raw)
To: Premila Devi <premiladevi.dayalan@agbnielsen.com>; +Cc: pgsql-sql
On Tue, Aug 11, 2009 at 1:54 PM, Premila Devi <
premiladevi.dayalan@agbnielsen.com> wrote:
> Dear All,
>
>
>
> I like to import (.CVS File) to postgreSql.Could anyone help me. May I
> know, what the requirement.
>
>
>
COPY command should be your friend in that case -->
http://www.postgresql.org/docs/8.3/static/sql-copy.html
--
Shoaib Mir
http://shoaibmir.wordpress.com/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Import (.CVS File) to postgreSql
2009-08-11 04:22 Re: Import (.CVS File) to postgreSql Shoaib Mir <shoaibmir@gmail.com>
@ 2009-08-11 04:58 ` Shoaib Mir <shoaibmir@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Shoaib Mir @ 2009-08-11 04:58 UTC (permalink / raw)
To: Premila Devi <premiladevi.dayalan@agbnielsen.com>; +Cc: pgsql-sql
On Tue, Aug 11, 2009 at 2:36 PM, Premila Devi <
premiladevi.dayalan@agbnielsen.com> wrote:
> Dear Sir,
>
>
>
> I am really don’t understand Sir. May I have a screenshot on how to make
> these configuration sir.
>
>
>
> The File is in CVS, as I attached before sir.
>
>
>
As I told you before just use the COPY command. You don't need to do any
configurations and all.. just use the CSV option with COPY as explained in
the manual. Its just like any other SQL statement once you have the database
server installed.
Please do not post privately to my email as its always better posting it to
the list.
--
Shoaib Mir
http://shoaibmir.wordpress.com/
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2009-08-11 05:12 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-08-11 03:54 Import (.CVS File) to postgreSql Premila Devi <premiladevi.dayalan@agbnielsen.com>
2009-08-11 05:12 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2009-08-11 04:22 Re: Import (.CVS File) to postgreSql Shoaib Mir <shoaibmir@gmail.com>
2009-08-11 04:58 ` Shoaib Mir <shoaibmir@gmail.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