[GENERAL] Query for importing and exporting data from a database

Hi,   I am using postgres 7.4.2 on Solaris. My unix system does not place a limitation of 2 GB on file size. If I export  a data from my database that causes the file size to be more than 2 GB, then that export fails (and vice versa for importing, i.e. if the file size is more than 3 GB,

Re: [GENERAL] Query for importing and exporting data from a database

Thanks for that! Is there any way I can check if my Postgres was compiled using that option or not? Yateen V. Joshi -Original Message- From: Douglas McNaught [mailto:[EMAIL PROTECTED] Sent: Thursday, May 26, 2005 8:49 PM To: Yateen Joshi Cc: pgsql-general@postgresql.org Subject: Re

[GENERAL] Single Row Table?

Hi,   I have got a table which is supposed to contain only one row. It does not have any primary keys defined. So, essentially, when a new insert happens in that table, I would like it (the insert) to fail if there is already a row existing in that table. How can I do that? Can I add an