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


Dear List,

I have managed some small databases with FoxPro, but something is not known by me to manage postgresql databases :(

I had created a database as 'postgres' user and  I tried the following as 'postgres' user too under Debian SID with postgresql 8.1:
(it seems to be a Hungarian version :-)  - FoxPro couldn't speak Hungarian)

# psql MediaBin
[...]
MediaBin=# \d media
        Tábla "public.media"
  Oszlop  |    Típus     | Módosító
----------+--------------+----------
type     | character(3) |
capacity | smallint     |
mid      | character(5) |

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

MediaBin=#


What the Hell could be wrong?







--

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

Attachment

pgsql-general by date:

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