Re: [SQL] [postgres] Copy Timestamp NULL

On Thursday 09 October 2003 09:55, Danny Tramnitzke wrote: (...) > Also es geht darum, dass ich in eine Postgres Tabelle per Copy Daten laden > möchte. > Bei einer Spalte handelt es sich um Timestamp NULL ... In der Source-Datei > befinden sich in dieser Spalte ISO Timestamp Werte und NULL - Werte

Re: [SQL] monitor sessions

SELECT * FROM pg_stat_activity; On Fri, 2003-10-10 at 09:48, Chris Faulkner wrote: Hello Can anyone tell me - is there a system table or view that I can query to show all current sessions ? Thanks Chris ---(end of broadcast)--- TIP 7: don

[SQL] monitor sessions

Hello Can anyone tell me - is there a system table or view that I can query to show all current sessions ? Thanks Chris ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [SQL] [GENERAL] SQL query problem (many table in FROM statement and many LEFT JOIN's)

On Friday 10 October 2003 08:53, Marek Lewczuk wrote: > > > SELECT > > > _CON.con_id, > > > > Please make sure you get the quoting right regarding table > > names. PostgreSQL will fold _CON into _con unless quoted > > "_CON". So, it may be that you created the table with quotes > > ("_CON"). Now,