On Thu, Jan 18, 2001 at 12:57:47PM -0500, Jeff Self wrote:
..
> But I'm getting an error because
> there are comments in the file. If I remove the comments, the file works.
> I am using the command: psql -e database < /home/dir/database.sql
>
> An example of the database.sql is this:
>
> # Table structure for table 'adminblock'
> #
...
> Is there a way to run this script without removing the comments?
How about
sed s/^#/--/
to get the standard SQL comment character(s)?
Cheers,
Patrick