man8db/pgdbload

Table of Contents

Name

pgdbload - load tuples into postgres database

Synopsis

pgdbload <dbname> <table_name> <spec_name> < list_of_tuples

Description

This program inserts or updates a database from a list of tuples.

The input should contain one tuple per line. Lines are terminated by a newline. Fields within a tuple are separated by a |.

Blank lines are ignored.

Lines starting with a # are treated as comments and ignored.

Arguments

dbname

The name of the postgres database to connect to.
table_name
The name of the table to update or insert tuples into.
spec_file
a file containing a list of input fields. Fields within the spec file correspond to field names within a Postgres table. | is used as a separator between fields.

Examples

Manual page revision

$Id: pgdbload.8,v 1.1 2000/07/24 02:44:44 kitchen Exp $


Table of Contents