Search Postgresql Archives

Re: pg_dump and boolean format

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux