Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Re: [SQL] Import (.CVS File) to postgreSql
13 views
Skip to first unread message
Shoaib Mir
Aug 11, 2009, 12:22:10 AM8/11/09
to
On Tue, Aug 11, 2009 at 1:54 PM, Premila Devi <premilade...@agbnielsen.com> wrote:
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/
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/
Shoaib Mir
Aug 11, 2009, 12:58:33 AM8/11/09
to
On Tue, Aug 11, 2009 at 2:36 PM, Premila Devi <premilade...@agbnielsen.com> wrote:
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.
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.
A. Kretschmer
Aug 11, 2009, 1:12:21 AM8/11/09
to
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.
> 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
--
Sent via pgsql-sql mailing list (pgsq...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
0 new messages