[SQL] [pgmail] - I have problems with pgmail

I install language and all codes ... but I have problems with text in french with accents "ééé èèè" The datas are correct in database but tcl does not recognize the format and trnasform accents when I send mail ! ... What could I do ? ---(end of broadcast)-

Re: [SQL] Recursive request ...

I see connect by in Oracle ??? is there an equivalent in PostgreSQL or not ?? Rajesh Kumar Mallah a écrit: Dear Bournon, There are already good implementation of Tree structures in databases ranging from using pure SQL to PostgreSQL specfic methods , less point in revinting wheel unl

[SQL] Is it possible to connect to another database

Hi, I try to find how is it possible to connect 2 databases, with a symbolic link. I have to use tables in another database to test user or other information. Ben ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

[SQL] Books in french

For all french people in this list : I search books about postgresql in French with explanations of tree structure functions, optimisation of install not novice books Thx a lot ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaste

[SQL] [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3

I have to duplicate a table to save different instances of datas. Structure de la table "spectacle" */ CREATE TABLE "spectacle" ( id_spectacle SERIAL, "id_membre_adherent" INTEGER NOT NULL, "id_genre_festival" INTEGER, "id_fes

Re: [SQL] [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3

No trigger Just triggers for foreign key in spectacle and none in spectacle_v How is it possible to verify triggers for foreign keys ? Stephan Szabo a écrit: On Fri, 8 Aug 2003, BenLaKnet wrote: When I duplicate this code in an other table named spectacle_v without Foreygn

Re: [SQL] [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3

ables ? Stephan Szabo a écrit: On Mon, 11 Aug 2003, BenLaKnet wrote: How could I do a pg_dump -s ?? on local server ?? Yes. I figured you wouldn't want to send your backups with data (I assume you have pg_dump generated backups ;) ). You can use pg_dump locally or remotely

Re: [SQL] Insert a description while creating a table

create table test ( id serial , name varchar(50)  );    COMMENT ON TABLE "test" IS 'MySQL table id_training_form ... id_form_unique'; comment on COLUMN "test"."id" is 'greigjreoigjreigjore iojrjiogre' ; Doc postgresql comment Rod Taylor wrote: On Wed, 2003-08-13 at 07:56, [E

Re: [SQL] [ZODB-Dev] What are the ZopeDB limit?

just one question You use zope with postgresql ?? No problem of connection ? Michele Bendazzoli wrote: On Mon, 2003-08-25 at 09:12, Michele Bendazzoli wrote: ops ... apologies for the message. Michele ---(end of broadcast)--- TIP 7: don't fo

[SQL] [pg-sql] Character encoding

How is it possible to convert a database in SQL_ASCII to UNICODE ? Thx a lot Regards Ben ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] connectby

I use postgresql 7.2.3 How can I use connectby ?? Must I install files ? or packages ? or it is recommanded to upgrade dataserver ? George Essig wrote: hi I have menu table: id | integer | not null default nextval('public.menu_id_seq'::text) parent_id | integer |

Re: [SQL] postgresql and ColdFusion

Benoît BOURNON wrote: Oh dear a man using CF with postgresql ! ... OH YES ! ... try to use jdbc pilot to connect to postgresql with CFMX ... maybe you can use cfstoredproc with cfprocparam and cfprocrsult Roberto Mello wrote: On Mon, Dec 08, 2003 at 05:38:56PM -0800, viol

Re: [SQL] Triggers

I try pgmail and that is well running ... fo security, do not use attachment files with your mail ... try pgmail, you need to use pl/tclu ... Ben Sai Hertz And Control Systems wrote: Dear Uzo  , Hi, does postgresql support the ability to email as in SQL Server? I want to cr

Re: [SQL] designer tool connect to PostgreSQL

Rekall ...     http://www.totalrekall.co.uk/         (commercial website)     http://www.rekallrevealed.org/      (free sources) for designing different RDBMS like mysql, postgresl, oracle and other ... free with sources ... but packages for windows or linux are not free. Ben Yasir Malik