Return to Snippet

Revision: 30029
at August 6, 2010 07:44 by jturmel


Initial Code
# Development Server

psql database_name
CREATE TABLE temp_table_name AS SELECT * FROM actual_table WHERE some_field = 'some_value' ORDER BY some_field;
\q

pg_dump -t temp_table_name database_name | gzip > temp_table_name.sql.gz
scp temp_table_name.sql.gz user@server:
psql database_name
DROP TABLE temp_table_name;

# Production Server

zcat temp_table_name.sql.gz | psql database_name
psql database_name
INSERT INTO actual_table SELECT * FROM temp_table_name;
DROP TABLE temp_table_name;

Initial URL


Initial Description


Initial Title
Export/import subset of data from table in Postgres

Initial Tags
table, data

Initial Language
Bash