Hi,
I have created a database view by :
CREATE VIEW V_EDUCATION_LEVEL ( id, description ) AS
SELECT 1, 'College or above'
UNION ALL
SELECT 2, 'Secondary';
I pg_dump(ed) the database by specifying a tar format and tried to
pg_restore to a destination database. However, I encountered the following
error:
pg_restore: creating VIEW v_education_level
pg_restore: [archiver (db)] could not execute query: ERROR: CREATE TABLE:
attribute "?column?" duplicated
pg_restore: *** aborted because of error
Any idea?
Thanks,
Pius