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

From Rodrigo Gonzalez
Subject Re: beginne' - inserting a record
Date
Msg-id 43921E5C.9050101@gmail.com
Whole thread Raw
In response to beginne' - inserting a record  (Andrew Toth <tothaa@chello.hu>)
List pgsql-general
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
>

pgsql-general by date:

Previous
From: "Raymond O'Donnell"
Date:
Subject: Re: beginne' - inserting a record
Next
From: "Uwe C. Schroeder"
Date:
Subject: Re: 8.1, OID's and plpgsql