[SQL] copy table

[Shavonne Marietta Wijesinghe]

Hello   How can i copy a table from one schema to another..   Example..   * I have a database "mydatabase" * then i have 2 schemas "myschema1" and "myschema2" * in "myschema1" i have inserted a new line and i want to copy that to "myschema2" so they both will be same..   How can i do it with SQL ??   I use pgadmin 3 to make my database in postgresql   thank u