[SQL] 3 options

Hi, Using : PostgreSQL 6.5.3 on i686-pc-linux-gnu Platform : Linux (Red Hat 6.0) 3 errors : 1) pg_dump medias > medias.pgdump280301 pqWait() -- connection not open PQendcopy: resetting connection SQL query to dump the contents of Table 'dossier' did not execute correctly. After we read all th

[SQL] out-subject : thanks

hi, i just "finish" a project using postgresql. i just want to thank's everyone from the mailing list who help me. in particular, bruce for your book (i wasn't a thing about database and sql 2 months ago). tom for your quick answer and eric l. http://www.mediacces.com in french... go to - media

[SQL] order by accents?

hi, if I do a query like this one : SELECT name from medias ORDER BY name name ÉCCC 6 rows Why the record : ÉCCC is at the end? HOW can I fix this? Thank you Patrick

[SQL] temporay table : error is repeated.

Let me try to explain why i want to use temporary tables, maybe you have others solutions for me (it's call experience) :) I use PHP to interact with postgres. 1) The "user" do is selection (form - checkbox). 2) Results. 3) Options : he can print it, save it, and make MODIFICATIONS. That's the

[SQL] find the number of rows for each table

Hi, I want to find the number of rows for each table (2) in 1 query, the query is: select distinct * from medias, contacts WHERE medias.media_id = contacts.media_id AND medias_categories.media_id = medias.media_id AND medias_categories.categorie_id = 1 700 rows If I want to find the