Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import psycopg2
- # Definição da conexão com a DB onde informo o nome, o usuário, a senha e o IP.
- conn = psycopg2.connect("dbname=dbname user=user password=password host=iphost")
- # Abertura da conexão para execução de queryes.
- cur = conn.cursor()
- # Query de consulta da tabela empresa. columns=None
- f = open("\\server\arquivos\BD\log.txt", "w")
- copy_to(f, 'wphd.empresa', sep=';', null='')
- f.close()
- # Fechar conexão com a DB.
- cur.close()
- conn.close()
- Traceback (most recent call last):
- File "C:PyDbConn_B_working.py", line 12, in <module>
- copy_to(f, 'wphd.empresa', sep=';', null='')
- NameError: name 'copy_to' is not defined
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement