Re: [HACKERS] some ideas from users

2014-11-22 Thread Pavel Stehule
2014-11-22 15:18 GMT+01:00 Andrew Dunstan : > > On 11/22/2014 06:20 AM, Pavel Stehule wrote: > >> Hi >> >> I did a week training and here are some ideas from people, who are >> starting with Postgres. >> >> 1. possibility to set server side variables simply as psql option. >> Motivation - more sim

Re: [HACKERS] some ideas from users

2014-11-22 Thread David G Johnston
Pavel Stehule wrote > : > > 2014-11-22 12:24 GMT+01:00 Marko Tiikkaja < > marko@ > >: > >> On 2014-11-22 12:20 PM, Pavel Stehule wrote: >> >>> 2. missing table function with all settings. Like SHOW ALL, but with >>> filtering possibility >>> >> >> What's wrong with pg_settings? >> > > nothing,

Re: [HACKERS] some ideas from users

2014-11-22 Thread Andrew Dunstan
On 11/22/2014 06:20 AM, Pavel Stehule wrote: Hi I did a week training and here are some ideas from people, who are starting with Postgres. 1. possibility to set server side variables simply as psql option. Motivation - more simple and natural changing datestyle for psql in shell scripts. "

Re: [HACKERS] some ideas from users

2014-11-22 Thread Pavel Stehule
2014-11-22 12:26 GMT+01:00 Antonin Houska : > On 11/22/2014 12:24 PM, Marko Tiikkaja wrote: > > On 2014-11-22 12:20 PM, Pavel Stehule wrote: > >> 2. missing table function with all settings. Like SHOW ALL, but with > >> filtering possibility > > > > What's wrong with pg_settings? > > Do you mean p

Re: [HACKERS] some ideas from users

2014-11-22 Thread Pavel Stehule
: 2014-11-22 12:24 GMT+01:00 Marko Tiikkaja : > On 2014-11-22 12:20 PM, Pavel Stehule wrote: > >> 2. missing table function with all settings. Like SHOW ALL, but with >> filtering possibility >> > > What's wrong with pg_settings? > nothing, I didn't find it in doc http://www.postgresql.org/docs/

Re: [HACKERS] some ideas from users

2014-11-22 Thread Antonin Houska
On 11/22/2014 12:24 PM, Marko Tiikkaja wrote: > On 2014-11-22 12:20 PM, Pavel Stehule wrote: >> 2. missing table function with all settings. Like SHOW ALL, but with >> filtering possibility > > What's wrong with pg_settings? Do you mean pg_show_all_settings() ? -- Antonin Houska Cybertec Schöni

Re: [HACKERS] some ideas from users

2014-11-22 Thread Marko Tiikkaja
On 2014-11-22 12:20 PM, Pavel Stehule wrote: 2. missing table function with all settings. Like SHOW ALL, but with filtering possibility What's wrong with pg_settings? .marko -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://w

[HACKERS] some ideas from users

2014-11-22 Thread Pavel Stehule
Hi I did a week training and here are some ideas from people, who are starting with Postgres. 1. possibility to set server side variables simply as psql option. Motivation - more simple and natural changing datestyle for psql in shell scripts. "--set" is allocated now, but theoretically we can us