[GENERAL] postgres on SuSE 9.1

Dear my friends... Usually I use MySQL. Now I have to migrate my database from MySQL to Postgres. I have created a database successfully with "creatdb" and a user account successfully. But I can not access the postgres with pgaccess. I found this error message : " Error trying to connect to dat

[GENERAL] MySQL to Postgres.

Dear my friends... I am planning to migrate my database from MySQL to Postgres since the MySQL does not have subquery except it 4.1. And I can not wait until the 4.1 stable version released and included in SuSE distro. I did mysqldump (into a file, basisdata.txt) and I am going to do its query qi

[GENERAL] mysql2postgres has no documentation?

Dear my friends... I am trying to nigrate my database from mysql to postgres. I have dump my databases qith mysqldump and put the result in a file ( named basisdata ). In order to make it be possible to be reloaded with psql, I want to convert the file with "mysql2pgsql.perl" tool. But I don't

[GENERAL] Trigger on Postgres for tables syncronization

Dear my friends... I am using SuSE Linux 9.1 and postgres. I am a beginner in postgres, usually I use MySQL. I have 3 tables : appointment, appointment0 and appointment1. the fields of table "appointment" are as follows: noapp* (int4):ID Number of appointment (PK) custid (int4)

Re: [GENERAL] Trigger on Postgres for tables syncronization

tic/sql-createview.html > on how to create a view. > > Cheers, > Csaba. > > On Tue, 2004-07-27 at 13:58, Prabu Subroto wrote: > > Dear my friends... > > > > I am using SuSE Linux 9.1 and postgres. I am a > > beginner in postgres, usually I use MySQL. >

Re: [GENERAL] Trigger on Postgres for tables syncronization

ead the postgres > documentation which is quite > good: > http://www.postgresql.org/docs/7.4/static/index.html > > > HTH, > Csaba. > > > On Tue, 2004-07-27 at 15:35, Prabu Subroto wrote: > > But I think, the modification of records to the > table > > "appo

Re: [GENERAL] altering a table to set serial function

ically. If I read your suggestion, that means...I have drop the column "salesid" and re-create the column "salesid". and it means, I will the data in the current "salesid" column. Do you have further suggestion? Thank you very much in advance. --- Scott Marlo

Re: [GENERAL] altering a starting value of "serial" macro

for instance to : "501" (the maximum current values of column salesid is 500). Anybody has a solution? Thank you very much in advance. --- Prabu Subroto <[EMAIL PROTECTED]> wrote: > Dear Scott... > > My God so I can not use "alter table" to define > a &g

Re: [GENERAL] altering a table to set serial function

This is exactly what I need.. Thank you very much for your kindness, Doug. Thank you...thank you...veryvery,,, much. --- Doug McNaught <[EMAIL PROTECTED]> wrote: > Prabu Subroto <[EMAIL PROTECTED]> writes: > > > If I read your suggestion, that means...I have > d

Re: [GENERAL] altering a starting value of "serial" macro

It's solved. Thank you very much for your kindness. --- John Sidney-Woollett <[EMAIL PROTECTED]> wrote: > You missed the command: > > SELECT setval('salesid_seq', (SELECT max(salesid) > FROM sales) + 1); > > John Sidney-Woollett > > Prabu Subroto wr

[GENERAL] I have some questions...

Dear my friends... My boss requested that my application is equipped with emoicon (smiley) in the sales report. That's why I need to know, is it possible to save a small image into the postgres? with which data type should I define the column (field)? I have a currently table, salesreport. Its fi

[GENERAL] insertiing an image file (blob) into postres...

Dear my friends I created a column with datatype bytea. The name of the column is emoicon I did like this: kv=# insert into salesreport (salesid, custid, emoicon) values('13', '4531', lo_import('/localhome/patrixlinux/arsip/proyek/qt/kv/client/images/1.png')); ERROR: column "emoicon" is of