Thread: beginne' - inserting a record

beginne' - inserting a record

From
Andrew Toth
Date:

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

Re: beginne' - inserting a record

From
Terry Lee Tucker
Date:
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

Re: beginne' - inserting a record

From
Andrew Toth
Date:
thx,

it's working!

And the last question - today:

how can i change the orter of the fields in a table?




2005-12-03, szo keltezéssel 20.59-kor Raymond O'Donnell ezt írta:
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@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------



--

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


Re: beginne' - inserting a record

From
Andreas Kretschmer
Date:
Andrew Toth <tothaa@chello.hu> schrieb:

> thx,
>
> it's working!
>
> And the last question - today:
>
> how can i change the orter of the fields in a table?

If you have a table with field1, field2, field3, and you want to see
this table as field3, field2, field1, simple do 'select field3, field2,
field1 from table'.

Btw.: TOFU (top posting with fullquote below) are silly.


HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

Re: beginne' - inserting a record

From
"Raymond O'Donnell"
Date:
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@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------


Re: beginne' - inserting a record

From
Rodrigo Gonzalez
Date:
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
>

Re: beginne' - inserting a record

From
Peter Wiersig
Date:
On Sat, Dec 03, 2005 at 09:48:42PM +0100, Andrew Toth wrote:
>
> MediaBin=# insert into media values ("000", 120, "00001");
> ERROR:  column "000" does not exist
>
> What the Hell could be wrong?

Your quotes. Use ' and that command will work.

Peter