The Postgres equivalent of the Microsoft command
Microsoft T-SQL
===
BULK INSERT 'database_name.owner.table_name'
FROM 'data_file'
WITH (FIRSTROW=2)
I like to store the column header names in row 1
Postgres
COPY tablename [ ( column [, ...] ) ]
FROM 'filename'
Both of the
ss is not about winning every battle, it is about winning the war"
-Original Message-
From: James Prichard [mailto:[EMAIL PROTECTED]
Sent: Monday, April 18, 2005 6:14 PM
To: pgadmin-support@postgresql.org
Cc: Sim Zacks; [EMAIL PROTECTED]
Subject: RE: [pgadmin-support] Query regarding Bu
b Spiders India
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Query regarding Bulk Import
I'd use DTS
Thank You
Sim Zacks
CIO
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
Hi,
I'
:26
To: Dheeman - Web Spiders India
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Query regarding Bulk Import
I'd use DTS
Thank You
Sim Zacks
CIO
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
_
I'd use DTS
Thank You
Sim Zacks
CIO
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
Hi,
I'm a new user of postgres. Earlier my database was sqlserver . now i want
to perform BULK IMPORT of data from Sqlserver to P
Hi,
I'm a new user of postgres.
Earlier my database was sqlserver . now i want to perform BULK IMPORT of data
from Sqlserver to Postgres. Can you please suggest what are the tools that might
be used in this purpose. Just to note that the data size in Sqlserver is of size
more than 10GB.
