Re: Query regarding Bulk Import

Поиск
Список
Период
Сортировка
От James Prichard
Тема Re: Query regarding Bulk Import
Дата
Msg-id A8D8891C40113445A567195896DC83AE8DFFB1@exch_svr.Dadd.local
обсуждение исходный текст
Ответ на Query regarding Bulk Import  ("Dheeman - Web Spiders India" <dheeman.dutta@webspiders.com>)
Список pgadmin-support
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 these work with tab delimited text flat files.

Dropping indices and avoiding locking and logging overheads is very
important to getting data in fast for Microsoft SQL Server, and
presumably Postgres.

I've not looked at DTS for dumping text from Microsoft.  For my smaller
database, an ADODB SELECT query and writing the record set to a text
file was quick enough.

-----Original Message-----

I'd use DTS

Thank You
Sim Zacks

-----Original Message-----
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.

Thanks & Regards,

Dheeman Dutta



В списке pgadmin-support по дате отправления:

Предыдущее
От: "Dheeman - Web Spiders India"
Дата:
Сообщение: Re: Query regarding Bulk Import
Следующее
От: juanmime@ono.com
Дата:
Сообщение: Create oid inside triggers in C