Re: " " around fields with psql

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: " " around fields with psql
Дата
Msg-id CAOR=d=2VmiHCZVsPL5WZYtY=taz=tzNch+3a5bqAGC7XQ1z-dg@mail.gmail.com
обсуждение исходный текст
Ответ на " " around fields with psql  (Steve Clark <sclark@netwolves.com>)
Ответы Re: " " around fields with psql
Список pgsql-general
On Fri, Feb 10, 2012 at 11:26 AM, Steve Clark <sclark@netwolves.com> wrote:
> Hello,
>
> Is there a way with psql to get column output to be
> "data1","data2",...,"datan"
>
> I tried -F "," but that left off the first and last quote.
>
> I can't seem to find a way in the man page.

Well, you can do it yourself kinda like this:

select '""||field1||'", "||field2||'" from sometable where yada.

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

Предыдущее
От: Steve Clark
Дата:
Сообщение: " " around fields with psql
Следующее
От: David Johnston
Дата:
Сообщение: Re: Strategy for Primary Key Generation When Populating Table