On Mon, Jun 17, 2019 at 4:24 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> > My cheat for dealing with many/long column names is: > > test=# \d up_test > Table "public.up_test" > Column | Type | Collation | Nullable | Default > --------+---------+-----------+----------+--------- > id | integer | | | > col1 | boolean | | | > col2 | integer | | | > > > > test=# \pset format unaligned > Output format is unaligned. > test=# \pset fieldsep ',' > Field separator is ",". > > select * from up_test limit 0; > id,col1,col2 > > Cut and paste above. > > test=# \pset fieldsep '|' > Field separator is "|". > > test=# \pset format 'aligned' > Output format is aligned. > > Just curious, but if you really do that often, wouldn't you be better off with something like this? CREATE OR REPLACE FUNCTION field_list( name ) RETURNS text AS $$ SELECT array_to_string(array_agg(column_name::text ORDER BY ordinal_position),',') FROM information_schema.columns WHERE table_name = $1; $$ LANGUAGE sql STABLE; Cheers, Ken -- AGENCY Software A Free Software data system By and for non-profits *http://agency-software.org/ <http://agency-software.org/>* *https://demo.agency-software.org/client <https://demo.agency-software.org/client>* ken.tan...@agency-software.org (253) 245-3801 Subscribe to the mailing list <agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn more about AGENCY or follow the discussion.
