Re: [DOCS] [GENERAL] how to select temp table
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 FUNCTION page. -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] [GENERAL] how to select temp table
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/static/ddl-schemas.html > > Apparently the only mention of pg_temp is in the CREATE FUNCTION page. That's probably not a good omission. Any ideas as to where further mentions should go? Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [email protected] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] [GENERAL] how to select temp table
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://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] [GENERAL] how to select temp table
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 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 but nothing else. Oh, I see the problem .. the index entry is "search_path configuration parameter". I think it would be better if it were search_pathconfiguration parameter -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] [GENERAL] how to select temp table
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: > > http://www.postgresql.org/docs/current/static/ddl-schemas.html > > > > Apparently the only mention of pg_temp is in the CREATE FUNCTION page. > > That's probably not a good omission. Any ideas as to where further > mentions should go? I think mentioning it in the page I link to above would be good. I can't think of any further places on which it should be mentioned. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] [GENERAL] how to select temp table
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 > but nothing else. > Oh, I see the problem .. the index entry is "search_path configuration > parameter". I think it would be better if it were > search_pathconfiguration parameter Seems like what you are describing is a bug in the search engine, not a problem we must address by doubling the vertical space needed for literally hundreds of index entries. regards, tom lane -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
Re: [DOCS] [GENERAL] how to select temp table
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-schemas.html#DDL-SCHEMAS-PATH > > but nothing else. > > > Oh, I see the problem .. the index entry is "search_path configuration > > parameter". I think it would be better if it were > > > search_pathconfiguration parameter > > Seems like what you are describing is a bug in the search engine, > not a problem we must address by doubling the vertical space needed for > literally hundreds of index entries. Yeah, perhaps ... I think it should suggest all index entries that start with the search string, not necessarily equal. Magnus? :-) -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
