On Tuesday 11. July 2006 15:22, Alvaro Herrera wrote:
>Leif B. Kristensen wrote:
>> It would be nice, though, if we had something like Oracle's
>> SQL-Loader for PostgreSQL. It's a very powerful tool for
>> transforming and loading data.
>
>We do have very powerful tools, even more powerful than S
Leif B. Kristensen wrote:
> On Tuesday 11. July 2006 10:10, A. Kretschmer wrote:
> >Do you have a UNIX-like operating system? Then you can use tools like
> >'cut':
> >
> >[EMAIL PROTECTED]:~$ echo "s1,s2,s3" | cut -d ',' -f 1,3
> >s1,s3
> >
> >This result can you pipe into psql.
>
> It would be ni
On Tuesday 11. July 2006 10:10, A. Kretschmer wrote:
>Do you have a UNIX-like operating system? Then you can use tools like
>'cut':
>
>[EMAIL PROTECTED]:~$ echo "s1,s2,s3" | cut -d ',' -f 1,3
>s1,s3
>
>This result can you pipe into psql.
It would be nice, though, if we had something like Oracle's
am 11.07.2006, um 9:24:06 +0200 mailte Christian Rengstl folgendes:
> Hi again everyone,
>
> i got it to work, but came across another question concerning COPY. If
> i have a column in a text file that i do not want/need in the
> database, is there a way not to read that column from the file wit
Hi again everyone,
i got it to work, but came across another question concerning COPY. If i have a
column in a text file that i do not want/need in the database, is there a way
not to read that column from the file without having to edit the file
beforehand?
Thanks for your advice!
"A. Kretsc
am 10.07.2006, um 10:21:59 +0200 mailte Christian Rengstl folgendes:
> Hi everyone,
>
> I have a table with a surrogate key which is an integer sequence. Is
> there a way to load a file using COPY and tell postgresql not to
> insert into the primary key column?
Yes:
test=# create table foobar (
Hi everyone,
I have a table with a surrogate key which is an integer sequence. Is there a
way to load a file using COPY and tell postgresql not to insert into the
primary key column?
Thanks!
Chris
--
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Uni
Nevermind. It was a problem with the encoding
type of the file.
--- Eduardo Muñoz <[EMAIL PROTECTED]> escribió:
> Hi, I'm trying to copy information from a csv file
> using pgadminIII. I run the following command:
>
> copy cliente from '/path/file.csv' with csv;
>
> The command runs and i
Hi, I'm trying to copy information from a csv file
using pgadminIII. I run the following command:
copy cliente from '/path/file.csv' with csv;
The command runs and i get no output. I thought the
process could be taking a lot to complete, but i don't
think so. I'm trying with just a few records an
On Mon, Jan 22, 2001 at 07:04:51PM +0530, Anand Raman wrote:
> hi guys
> While trying to isnert data into a table using the \copy i am getting a
> error which states Bad timestamp representation..
> I am not sure why it is occuring..
> Can some one point out what this mistake is ..
> My datestyle
Hi there.
I have some problems with importing a large txt db into postgres ... I try to use the
\copy db from xyz to import from a tabulator spaced textfile ... it takes 2-3sec then
a "broken pipe" comes up and psql is beeing left
anyone knows if there's a possibility to turn on something
11 matches
Mail list logo
