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 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
Chapman [mailto:[EMAIL PROTECTED]
Sent: 11 March 2005 03:46
To: James Prichard; 'On Behalf Of David Chapman'
Subject: Thanks for your help
Thanks James and Dave,
I had two problems. The screen resolution of 800 * 600 chops off the
bottom of the screen on which columns can be added to a ne
A
postgresql server may contain multiple databases and each of these can have its
own set of user permissions. Just opening pgadminIII doesn’t authorize
you to do anything – or even to see much!
The
pgadminIII application must first connect to a database as a particular
user. E.g. th
pgAdmin3 Version 1.3.0 (Mar 3 2005)
running on Win 2000 Pro (IA32)
MINOR GLITCH REPORT
- the "aggfunction(argtype)" is necessary for changing owner whereas
the reverse engineered sql display shows just the "aggfunction"
- a prior version of pgAdmin3 had a similar error in the sql to drop
th
