Re: beginne' - inserting a record - Mailing list pgsql-general

From Andrew Toth
Subject Re: beginne' - inserting a record
Date
Msg-id 1133644141.9402.26.camel@edvac4
Whole thread Raw
In response to beginne' - inserting a record  (Andrew Toth <tothaa@chello.hu>)
Responses Re: beginne' - inserting a record
List pgsql-general
thx,

it's working!

And the last question - today:

how can i change the orter of the fields in a table?




2005-12-03, szo keltezéssel 20.59-kor Raymond O'Donnell ezt írta:
On 3 Dec 2005 at 21:48, Andrew Toth wrote:

> MediaBin=# insert into media values ("000", 120, "00001");
> ERROR:  column "000" does not exist

I think you should use single-quotes rather than doubles:

  insert into media values ('000', 120, '00001');

--Ray.

-------------------------------------------------------------
Raymond O'Donnell     http://www.galwaycathedral.org/recitals
rod@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------



--

Tisztelettel: / Grüße / Yours sincerely,
   Andrew Toth


pgsql-general by date:

Previous
From: Terry Lee Tucker
Date:
Subject: Re: beginne' - inserting a record
Next
From: Andreas Kretschmer
Date:
Subject: Re: beginne' - inserting a record