Hello,
I'm developping a C function, that will be executed in triggers (similar
a lo_manage, see contrib).
This function will create an oid for one of the columns. Think in a table
with two oid columns:
create table example (img oid, thumb oid);
img field contains an image and thumb, the thumbn
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
Hi James/Sim,
Thanks for the immediate support regarding the BULK IMPORT.
Thanks & Regards,
Dheeman Dutta
Application Developer
Web Spiders (India) Pvt. Ltd.
51B, Justice Chandra Madhav Road
Calcutta 700 020. India
Phone: 91.33.2474.3581 to 85
Fax: 91.33.2474.3500
http://www.webspiders.com/
(IS
James,
I was unaware that you could BCP data from SQL server to PostGreSQL. I
will have to look into that for the future.
Thank You
Sim Zacks
CIO
CompuLab
04-829-0145 - Office
04-832-5251 - Fax
Hi Sim / Dheeman
D
Hi Sim / Dheeman
DTS is designed for scripts that batch more complex tasks. It is best
not to do any transformation if your aim is to achieve a bulk copy.
In my experience, T-SQL's Bulk Insert gives the best speed, at least for
a few 100 megabytes of Tab Delimited file, and I always copy the fil
Hi,
Sorry about this repost, but I'm still facing a segmentation fault with pgAdmin III 1.2.1 and wxWidgets 2.5.5 on Red Hat Linux 8, and I can't find a workaround.
To avoid a first segmentation fault problem, I've set another Gnome theme. I can now see the pgAdmin splash window, but unfortunat
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.
