Re: How to load data in psql DB

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "pgsql-admin@xxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxx>
Subject: Re: How to load data in psql DB
From: Arnaud Gambonnet <arnaud.gambonnet@xxxxxxxxx>
Date: Wed, 31 May 2017 09:33:20 +0200
Arc-authentication-results: i=1; mx.google.com; dkim=pass header.i=@gmail.com; spf=pass (google.com: best guess record for domain of pgsql-admin-owner+m46715=spinic=gmail.com@xxxxxxxxxxxxxx designates 2a02:16a8:dc51::56 as permitted sender) smtp.mailfrom=pgsql-admin-owner+M46715=spinic=gmail.com@xxxxxxxxxxxxxx; dmarc=pass (p=NONE sp=NONE dis=NONE) header.from=gmail.com
Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20160816; h=sender:precedence:list-unsubscribe:list-subscribe:list-post :list-owner:list-id:list-help:list-archive:to:subject:message-id :date:from:references:in-reply-to:mime-version:dkim-signature :arc-authentication-results; bh=7u99qVwT0tuwSOpXPGFMslTm8JGVkTcXE5+rI5ORXM0=; b=JWOa3vkrR70HFEeRtbYpCdAh78FqQrf1uAJxjYsAK0nx+rhAWMEskMPfutv5q7EFXP lNeifY9c+c7im1oMFYaOXvRR66PZddXXEnfxFdn/mlPshpuYP20zE7WW8cQhmHScyunc cjWyTUXLeA4WZwmmcJr/44xLZCaCdxSIb8LCs9Df7HKte74j7RJCLMwx7Ds0X/NTtT8J 4VHGCuYK7QoTNHbo/N1HT53LL2SWG+weGv+VBpIksuh6sgbQvUeuAcRT6sa7wcbtCIX4 UZoFpOExElkprI33JTZTw+ezLSaxfO84hC7y90CWokRiEmRXfn8hXCEOcdJdjQL/XXYa NuPg==
Arc-seal: i=1; a=rsa-sha256; t=1496216044; cv=none; d=google.com; s=arc-20160816; b=kv7h8fLS/ztQUc7x6WiEtG2wMI1RvIJQA0SDgqS9PCP/h7qBegEpDcekn/ktpWthWV oQNF5uKey6dvIRVgcm32W2rmYX3RgvUCF65WFLD5Hr1WTI6GFCWCYPgxcanJyuk8jU2+ NN1fvF5vkhvwnUJj+fddxb1I7QXSI32XmFrYDOltABHkFT3gtLz5xnb+9kYRF8RD2XqU exNa0Tc2Ianh4F6hRcd2Ssm3dcXK6MLJBHrGU0B9rnKF0JIbOSXWZ0I6YebxStoEtkPb EYI76qL/b10KCtP/nHc5RakYQ2Tf/V3AElvSyPiXwufS2+e5CkG9RZ9HW2Awnvjd4jRJ 44mg==
In-reply-to: <AM3PR07MB35497930F2C4FABB67B75D5C0F10@AM3PR07MB354.eurprd07.prod.outlook.com>
References: <AM3PR07MB35497930F2C4FABB67B75D5C0F10@AM3PR07MB354.eurprd07.prod.outlook.com>

Hi,

pgloader should fit your need.

Regards,

AG.

2017-05-31 8:30 GMT+02:00 Ashwani Kumar B <ashwani.b.kumar@xxxxxxxxxxxx>:

Hi

My requirement is to automatically load data which is in CSV format to psql DB table.

Normally in oracle I use to do it through sql-loader [sqlldr] . Do we have anything similar in psql.

Regards

Ashwani

Follow-Ups:
- Re: How to load data in psql DB
  - From: Ashwani Kumar B

References:
- How to load data in psql DB
  - From: Ashwani Kumar B

Prev by Date: How to load data in psql DB
Next by Date: Re: How to load data in psql DB
Previous by thread: How to load data in psql DB
Next by thread: Re: How to load data in psql DB
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]