Is there a Postgres utility that allows data contained in a CSV file to be
loaded into the database?
I've backed up my DB via 'pg_dump dbname' using no options. In order to restore
it via psql, do I first need to drop the db instance and recreate it?
Thanks in advance for your help.
-Mike
In looking at SuSE's download site, I see two available RPMs: postgresql and
postgresql-server. It may be a novice question, but thn I am a Postgres novice.
What exactly is the difference?
I'm a newb running Postgres 8.3 on a SuSE 7.2 system. I have a database whose
size reports as 644 MB using
select pg_size_pretty(pg_database_size('adempiere'));
When using the following command to back up the database,
su postgres -c "pg_dump adempiere | split -b 3000m - /tmp/adempiere_`date
I'm a newb to Postgres, and need some assistance with pg_toast. I'm running
PostgreSQL 8.3, and am having an issue with one of my pg_toast tables growing
at the rate of 1 GB per day. Can someone offer me some insight on
a) the functionality of the pg_toast_* tables?
b) how can I clear them o
