Question : Let’s say I have some sample data, 100 million rows. CREATE TEMP TABLE foo AS SELECT id, md5(id::text), […]
Tag: ctas
CREATE TABLE AS vs SELECT INTO
Question : PostgreSQL supports CREATE TABLE AS and SELECT INTO when do I use both? CREATE TABLE AS — define […]
When does a table get an oid?
Question : I’m wondering when a table acquires an oid. Is it only when the transaction commits? Or does it […]
How do you CREATE TABLE AS SELECT (CTAS) with a composite type?
Question : PostgreSQL supports CREATE TABLE AS SELECT (CTAS). It also supports composite types that can represent whole rows. Here […]
Reducing CREATE TABLE overhead?
Question : I have a simple SQL query: SELECT * FROM table; – a simple sequential scan – which takes […]
ORA-01536: Out of space error when doing CTAS
Question : I have two schemas A and B. I’m trying to copy over table B.users to A. I’ve followed […]
How to find error rows in bulk insert?
Question : MySQL 5.6: I’m experimenting with copying data from one table to another in different ways. The source table […]