Thread: beginne' - inserting a record

beginne' - inserting a record

From

Andrew Toth

Date:

03 December 2005, 19:48:49

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

--

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

Attachment

Re: beginne' - inserting a record

From

Terry Lee Tucker

Date:

03 December 2005, 19:56:15

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:

03 December 2005, 20:09:07

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:

03 December 2005, 20:16:24

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:

03 December 2005, 20:28:34

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:

03 December 2005, 21:38:28

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:

03 December 2005, 23:07:16

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