Selecting all but a few fields in a query

Поиск
Список
Период
Сортировка
От thefronny@gmail.com
Тема Selecting all but a few fields in a query
Дата
Msg-id 1194281113.870030.15380@v29g2000prd.googlegroups.com
обсуждение исходный текст
Ответы Re: Selecting all but a few fields in a query
Re: Selecting all but a few fields in a query
Список pgsql-general
I have a table with a lot of fields, some of which are type TEXT. I
seem to have a lot of occasions where I'd like to see almost all of
the fields in a query but a SELECT * will pull in the text fields,
which then wrap across the screen, even using \x. Is there a variation
of SELECT that is something like 'select all fields except these here
WHERE...'? This would save me a lot of typing. I checked the docs but
missed it if it's in there.


thx

r


В списке pgsql-general по дате отправления:

Предыдущее
От: Abandoned
Дата:
Сообщение: Re: Copy the database..
Следующее
От: Lew
Дата:
Сообщение: Re: What makes a Postgres DBA?