Use the pg_dump command:
$ pg_dump DBNAME > FILENAME.sql
pg_dump takes the same parameters as psql, so if you have to connect to
an external db then you can specify it in a similar fashion to pg_dump.
i hope this helps.
good luck,
- lex
On Mon, 2003-01-13 at 18:04, Cheryl Thompson wrote:
> Is there a way to copy/export the DB (or it's tables) to another DB and dump
> all this stuff that's causing the problems? In particular, in the past I
> have exported the entirety of a database into a flat file and imported it
> into a "clean" version. Admittedly, it's been a while and that was for an
> app using DB2 which didn't have a lot of built in tools, but the theory
> applies...
>
> B/c building an ODBC driver is WAYYYY beyond 1)my skills and 2)the project
> timescale on this. I need to have this particular issue fixed tomorrow
> morning; if rebuilding the DB is the quickest way, I will do that, but I was
> hoping for a quicker (and less destructive) work around...
>
> Cheryl
>
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>
> Cheryl Thompson <cthompso@ci.irving.tx.us> writes:
> > All my installs and drivers are the newest official releases that were
> > available as of Dec 29, 2002. (IE 2 weeks ago)...
>
> I looked at the psqlodbc CVS logs, and this was claimed to be fixed on 6
> Dec --- but apparently there hasn't been a release put out since 29 Nov.
> I'd suggest pestering the ODBC guys for a new release (pgsql-odbc
> mailing list is probably a good place). Or pull the CVS-tip sources and
> build it yourself.
>
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>
> Cheryl Thompson <cthompso@ci.irving.tx.us> writes:
> > I'm getting the following:
> > '..............pg.dropped.8........................' is not a valid name.
>
> Are you using an up-to-date ODBC driver? It looks like the one you have
> is not aware of the attisdropped column in pg_attribute ...
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
