I'm not familiar with version 8.1; however, you to use single quotes, not
double quotes as in:
INSERT INTO media VALUES ('000', 120, '00001');
That should work...
On Saturday 03 December 2005 03:48 pm, Andrew Toth saith:
> 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