Re: pg_dump and boolean format

On Aug 11, 2010, at 3:57 PM, Michael Glaesemann wrote:

>
> On Aug 11, 2010, at 18:21 , Scott Frankel wrote:
>
>>
>> On Aug 11, 2010, at 10:12 AM, Michael Glaesemann wrote:
>>
>>> One option is to use COPY to export the data in a format you like.
>>> For example: COPY (SELECT CAST(boolean_column AS INT) FROM
>>> my_table) TO STDOUT. Then write a script which reads the exported
>>> data files and loads them into your sqlite database. COPY WITH CSV
>>> would likely be helpful as well.
>>
>> With the number of tables and insert statements I'll be wrangling,
>> I was hopeful I could coerce pg_dump to perform the "AS INT" cast.
>
> Query the database Information Schema or system tables to provide a
> list of the table names. By using COPY WITH CSV HEADER and the names
> of the tables, you should be able to generate INSERT statements
> programatically.

Good point. Thanks for the suggestions!
Scott

> Michael Glaesemann
> grzm seespotcode net
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>