The second command, COPY, generates a CSV file on the server where the database is running. This command takes the specified table or query results and writes them to the client’s computer. The first is the \copy meta-command which is used to generate a client CSV file. In psql there are two commands that can do this, both slightly different. Many tools support importing data from CSV files because it is an easy to read format that is plain text and not metadata dependent. header: this tells copy command to include the headers at the top of the document.Ĭomma Separated Value (CSV) files are a useful format for storing data.csv: this tells the copy command that the file being created should be a CSV file.In order to export a table or query to csv use one of the following commands:įor Client-Side Export: \copy to '' csv headerįor Server-Side Export: COPY to '' csv header Įxample Absolute Path: ‘/Users/matt/Desktop/filename.csv’Įxample Relative Path: ‘Desktop/filename.csv’
0 kommentar(er)
