Re: beginne' - inserting a record

From: "Raymond O'Donnell" <rod(at)iol(dot)ie>
To: Andrew Toth <tothaa(at)chello(dot)hu>, pgsql-general(at)postgresql(dot)org
Subject: Re: beginne' - inserting a record
Date: 2005-12-03 20:59:13
Message-ID: 43920721.18519.1CC02A2@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)iol(dot)ie Galway Cathedral Recitals
-------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Toth 2005-12-03 21:09:01 Re: beginne' - inserting a record
Previous Message Terry Lee Tucker 2005-12-03 20:55:36 Re: beginne' - inserting a record