[GENERAL] datatype questions

1998-06-22 Thread Brian
I am trying to convert a table into PostgresSQL from MySQL, and had a few questions: CREATE TABLE forum ( id int(11) DEFAULT '0' NOT NULL auto_increment, name varchar(30), email varchar(100), topic varchar(50), body blob, host varchar(50), thread int(11) DEFAULT '0' NOT NULL, date

[GENERAL] Importing delimited files

1998-06-22 Thread kheflin
I've usually imported any delimited text files into my PostgreSQL databases using "PGACCESS" which has worked great for me. Our System Admin here is wanting to import a delimited text file into a postgresql database using the psql command line... any suggestions? Kevin --