Re: beginne' - inserting a record

[Rodrigo Gonzalez <rjgonzale@xxxxxxxxx>]

dont use " user '

Andrew Toth wrote:

> 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