Thomas J Keller wrote:
> Excellent.
> So the first step is to create an empty table:
>
> passwords=# CREATE TABLE foo_bar LIKE original_table;
> ERROR: syntax error at or near "LIKE" at character 22
> LINE 1: CREATE TABLE foo_bar LIKE original_table;
SQL doesn't have this "do what I mean" feature yet :-)
Try
SELECT DISTINCT * FROM original_table INTO foobar;
This will create foobar with the same columns as original_table, and put
all non-duplicate tuples from original_table in it.
Vassilis.