Re: [DOCS] [GENERAL] how to select temp table

2009-05-06 Thread Alvaro Herrera
Alvaro Herrera escribió: > Note that you can refer to the temp table like this: > > select * from pg_temp.testtable; BTW I found no mention of pg_temp in the doc page here: http://www.postgresql.org/docs/current/static/ddl-schemas.html Apparently the only mention of pg_temp is in the CREATE FUN

Re: [DOCS] [GENERAL] how to select temp table

2009-05-06 Thread David Fetter
On Wed, May 06, 2009 at 03:27:28PM -0400, Alvaro Herrera wrote: > Alvaro Herrera escribió: > > > Note that you can refer to the temp table like this: > > > > select * from pg_temp.testtable; > > BTW I found no mention of pg_temp in the doc page here: > http://www.postgresql.org/docs/current/stat

Re: [DOCS] [GENERAL] how to select temp table

2009-05-06 Thread Tom Lane
Alvaro Herrera writes: > Apparently the only mention of pg_temp is in the CREATE FUNCTION page. It's also described under the search_path GUC. regards, tom lane -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://

Re: [DOCS] [GENERAL] how to select temp table

2009-05-06 Thread Alvaro Herrera
Tom Lane escribió: > Alvaro Herrera writes: > > Apparently the only mention of pg_temp is in the CREATE FUNCTION page. > > It's also described under the search_path GUC. Hmm, we have another problem then, which is that GUC vars are not showing in the search results when you search for their name

Re: [DOCS] [GENERAL] how to select temp table

2009-05-06 Thread Alvaro Herrera
David Fetter escribió: > On Wed, May 06, 2009 at 03:27:28PM -0400, Alvaro Herrera wrote: > > Alvaro Herrera escribió: > > > > > Note that you can refer to the temp table like this: > > > > > > select * from pg_temp.testtable; > > > > BTW I found no mention of pg_temp in the doc page here: > > ht

Re: [DOCS] [GENERAL] how to select temp table

2009-05-06 Thread Tom Lane
Alvaro Herrera writes: > Hmm, we have another problem then, which is that GUC vars are not > showing in the search results when you search for their names. For > example if I search for search_path I am suggested > http://www.postgresql.org/docs/current/static/ddl-schemas.html#DDL-SCHEMAS-PATH >

Re: [DOCS] [GENERAL] how to select temp table

2009-05-06 Thread Alvaro Herrera
Tom Lane escribió: > Alvaro Herrera writes: > > Hmm, we have another problem then, which is that GUC vars are not > > showing in the search results when you search for their names. For > > example if I search for search_path I am suggested > > http://www.postgresql.org/docs/current/static/ddl-sc