Changes
Jump to navigation
Jump to search
← Older edit
Newer edit →
Patent Data Processing - SQL Steps
(view source)
Revision as of 16:58, 23 June 2016
3 bytes added
,
16:58, 23 June 2016
→Sample Insert and Copy Statements
(
SELECT
patent,
kind,
gdate,
'NULL',
'NULL',
NULL,
NULL,
'NULL',
'NULL',
\COPY patents FROM '/tmp/merged_patents_export.txt' DELIMITER AS E'\t' HEADER NULL AS '' CSV;
-- RESULT : COPY 1646225
====TESTING ====
RavaliKruthiventi
Bureaucrats
,
Administrators (Semantic MediaWiki)
,
Administrators
154
edits
Navigation menu
Personal tools
Log in
Request account
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
Navigation
Sites
Wiki
Articles
Sections
Projects
Papers in Development
Paper Reviews
Team Members
Legislation
Research Computing
Organizations
Incubator Project
McNair Center
Berkeley's BPP Group
NBER Patent Data
Help
General help
Team help
Administration
Batch Upload Files
Tools
Special pages