michael@xxxxxxxxxxxx (Michael Romagnoli) writes:
> What kind of command would I run if I wanted to copy an entire table
> (along with renaming it, and, of course, all data from the first table
> -
> some of which is binary)?
SELECT * INTO newtable FROM oldtable;
Note that this doesn't construct indexes, Foreign keys, constraints,
etc.
If by 'binary data' you mean BLOBs, I'd expect the above to work.
Other than that, AFAIUI you have no reasonable expectation that your data is
stored in any meaningful binary format by the database. All data
could be internally stored as strings (though that might be very
slow).
--
Remove -42 for email
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
