Howdy:
Running PostgreSQL 7.3.3 on RedHat Linux 7.2
I'm trying to dump a table out with the insert
statements imbedded and I'm not having any success.
The man page for pg_dump says to use:
-d / -D to add the inserts (and values)
-f to send output to a file
-O for no owner
-t is for the table only
This is my command line version:
[[ /raid/pgsql/bin/pg_dump -D -t sys_test -f outtie test_db ]]
and this is the results:
[snip]
--
-- PostgreSQL database dump
--
[/snip]
What is the correct way to dump data and table structure
into a file with the insert / values in the file?
Thanks!
-X