Re: [SQL] Desc Commnad in pgsql?

2008-04-20 Thread TJ O'Donnell
I like the table and other info from psql and find I sometimes need that info in my client programs. Are there any SQL/plpgsql functions that are analogous to the psql \dt, \ds, etc. commands? For example create function d_table(table_name text) returns setof record that could be used in SQL comma

[SQL] Error: could not find pathkey item to sort

2008-04-20 Thread Theerasak Maneeneim
Hi Everyone, I had some problem with postgresql 8.3.1. I had got an error message, ERROR: could not find pathkey item to sort, when I use this query statement: SELECT INTO wk_fcstrec_dt DISTINCT MAX(fcstrec_dt) FROM a_cusfcst WHERE