> The data in the dump file are structured and I want to execute this
> automatically (copy+paste it) in the EMS software.
> I still get the syntax error even if I use the command you send me:
> COPY artikkel (id, tittel, tekst) FROM stdin; 1Title
oneSome
> text \.
Why not just load the du
Klas Stockhem wrote:
> Does the php engine interpret the big P like a small one?
It's not PHP, but PostgreSQL itself. All names in PostgreSQL are case
insensitive unless you double-quote them. PostgreSQL actually translates
everything to lower-case internally.
CREATE TABLE1 .
Klas Stockhem wrote:
> The data in the dump file are structured and I want to execute this
> automatically (copy+paste it) in the EMS software.
> I still get the syntax error even if I use the command you send me:
> COPY artikkel (id, tittel, tekst) FROM stdin; 1Title oneSome
> text \.
Why not j
Klas Stockhem wrote:
> Does the php engine interpret the big P like a small one?
It's not PHP, but PostgreSQL itself. All names in PostgreSQL are case
insensitive unless you double-quote them. PostgreSQL actually translates
everything to lower-case internally.
CREATE TABLE1 ...;-- gives "
-Ursprungligt meddelande-
Från: Richard Huxton [mailto:d...@archonet.com]
Skickat: den 4 augusti 2009 15:27
Till: Klas Stockhem
Kopia: PostgreSQL
Ämne: Re: SV: [SQL] Problems when copy data from dump file
Klas Stockhem wrote:
> Thanks for your mail!
Remember to cc: the mailing l
Klas Stockhem wrote:
Thanks for your mail!
Remember to cc: the mailing list too. Just hit "reply to all".
Oh, and perhaps don't top-quote. It makes it difficult for others to
follow the message.
1. Yes, the 5 and other text are at line 2 (a new line). I tried to put
the whole command on th
Klas Stockhem wrote:
SQL error:
ERROR: syntax error at or near "5"
LINE 2: 5 Slitasje og vedlikehold PRAKTISKE OPPLYSNINGER\r\n\r\nSn&#...
^
COPY artikkel (id, tittel, tekst) FROM stdin;
5Slitasje og vedlikeholdPRAKTISKE
OPPLYSNINGER\r\n\r\nSnø og i
I get an error when I'm trying to fill my table with data. I have a
postgresql dump file and copy-paste the text from the file into my
webbased phppgadmin interface. I have created my tables correctly.
Down here I have post the error message I get. I suppose it's something
with the tab between "5"
I get an error when I'm trying to fill my table with data. I have a
postgresql dump file and copy-paste the text from the file into my
webbased phppgadmin interface. I have created my tables correctly.
Down here I have post the error message I get. I suppose it's something
with the tab between
