Wang, Mary Y wrote:
> Hi,
>
> I'm using a psql -f command to reload the data from a dump file. I
> noticed that some tables are not populated with any rows (I mean 0
> rows), yet, if I manually insert a row (actually just copy an INSERT
> statement from that input file) in the interactive termina
On 06/07/2010 02:10 PM, Wang, Mary Y wrote:
That's good to know. I ended up manually copy/paste INSERT statements for each
table to another file and rerun the psql -f again. It was painful!
Mary
For future reference you could do something like:
pg_dump -a -t table_name -f table_name_data.s
Sent: Monday, June 07, 2010 11:21 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Does psql -f quit insertion after an error in a
statement has been detected?
On Sun, Jun 6, 2010 at 5:29 PM, Wang, Mary Y wrote:
> I'm using a psql -f command to reload the data from a dump fil
On Sun, Jun 6, 2010 at 5:29 PM, Wang, Mary Y wrote:
> I'm using a psql -f command to reload the data from a dump file. I noticed
> that some tables are not populated with any rows (I mean 0 rows), yet, if I
> manually insert a row (actually just copy an INSERT statement from that input
> file)
Wang, Mary Y wrote:
Hi,
I'm using a psql -f command to reload the data from a dump file. I noticed that some
tables are not populated with any rows (I mean 0 rows), yet, if I manually insert a row
(actually just copy an INSERT statement from that input file) in the interactive
terminal, that
Hi,
I'm using a psql -f command to reload the data from a dump file. I noticed
that some tables are not populated with any rows (I mean 0 rows), yet, if I
manually insert a row (actually just copy an INSERT statement from that input
file) in the interactive terminal, that row was added with no