SyntaxFix

[postgresql] How should I import data from CSV into a Postgres table using pgAdmin 3?

assuming you have a SQL table called mydata - you can load data from a csv file as follows:

COPY MYDATA FROM '<PATH>/MYDATA.CSV' CSV HEADER;

For more details refer to: http://www.postgresql.org/docs/9.2/static/sql-copy.html

Examples related to postgresql

• Subtracting 1 day from a timestamp date • pgadmin4 : postgresql application server could not be contacted. • Psql could not connect to server: No such file or directory, 5432 error? • How to persist data in a dockerized postgres database using volumes • input file appears to be a text format dump. Please use psql • Postgres: check if array field contains value? • Add timestamp column with default NOW() for new rows only • Can't connect to Postgresql on port 5432 • How to insert current datetime in postgresql insert query • Connecting to Postgresql in a docker container from outside

Examples related to pgadmin

• How connect Postgres to localhost server using pgAdmin on Ubuntu? • How should I import data from CSV into a Postgres table using pgAdmin 3? • Export and import table dump (.sql) using pgAdmin • Export Postgresql table data using pgAdmin • PostgreSQL how to see which queries have run • Postgresql: password authentication failed for user "postgres" • Unable to connect PostgreSQL to remote database using pgAdmin