/SQL/Copy table postgres

Copy table postgres

Copy table postgres

CREATE TABLE new_table AS 
SELECT
*
FROM
    existing_table
WHERE
    condition;

2

Postgres copy table from one schema to another

create table schema2.the_table (like schema1.the_table including all);
insert into schema2.the_table
select * 
from schema1.the_table;

1

Source: stackoverflow.com

Copy table postgres

CREATE TABLE new_table AS 
TABLE existing_table;

1

Source: postgresqltutorial.com

Similar codes

0 vote125 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote129 views1 answer
C# execute transact sql
SQL
1 vote152 views1 answer
Mysql default port
SQL
0 vote117 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote144 views1 answer
Alter domain sql
SQL
10 votes140 views6 answers
Mysql set root password
SQL
0 vote170 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
1 vote119 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
10 votes130 views2 answers
What is database
SQL
0 vote109 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL

Share