Обсуждение: Import (.CVS File) to postgreSql

Поиск

Список

Период

Сортировка

Import (.CVS File) to postgreSql

От

"Premila Devi"

Дата:

11 августа 2009 г., 01:17:47

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.

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.

Re: Import (.CVS File) to postgreSql

От

Shoaib Mir

Дата:

11 августа 2009 г., 01:22:14

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/

Re: Import (.CVS File) to postgreSql

От

Shoaib Mir

Дата:

11 августа 2009 г., 01:58:46

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/

Re: Import (.CVS File) to postgreSql

От

"A. Kretschmer"

Дата:

11 августа 2009 г., 02:12:35

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Import (.CVS File) to postgreSql

Import (.CVS File) to postgreSql

Re: Import (.CVS File) to postgreSql

Re: Import (.CVS File) to postgreSql

Re: Import (.CVS File) to postgreSql