1*0Sstevel@tonic-gateNAME 2*0Sstevel@tonic-gate rdb2pg - insert an rdb table into a PostgreSQL database 3*0Sstevel@tonic-gate 4*0Sstevel@tonic-gateSYNOPSIS 5*0Sstevel@tonic-gate rdb2pg [*param*=*value* ...] 6*0Sstevel@tonic-gate 7*0Sstevel@tonic-gatePARAMETERS 8*0Sstevel@tonic-gate rdb2pg uses an IRAF-compatible parameter interface. A template parameter 9*0Sstevel@tonic-gate file is in /proj/axaf/simul/lib/uparm/rdb2pg.par. 10*0Sstevel@tonic-gate 11*0Sstevel@tonic-gate input *file* 12*0Sstevel@tonic-gate The RDB file to insert into the database. If the given name is the 13*0Sstevel@tonic-gate string `stdin', it reads from the UNIX standard input stream. 14*0Sstevel@tonic-gate 15*0Sstevel@tonic-gateDESCRIPTION 16*0Sstevel@tonic-gate rdb2pg will enter the data from an RDB database into a PostgreSQL 17*0Sstevel@tonic-gate database table, optionally creating the database and the table if they 18*0Sstevel@tonic-gate do not exist. It automatically determines the PostgreSQL data type from 19*0Sstevel@tonic-gate the column definition in the RDB file, but may be overriden via a series 20*0Sstevel@tonic-gate of definition files or directly via one of its parameters. 21*0Sstevel@tonic-gate 22*0Sstevel@tonic-gate The target database and table are specified by the `db' and `table' 23*0Sstevel@tonic-gate parameters. If they do not exist, and the `createdb' parameter is set, 24*0Sstevel@tonic-gate they will be created. Table field definitions are determined in the 25*0Sstevel@tonic-gate following order: 26*0Sstevel@tonic-gate 27