Re: ERROR when inserting csv values into sql table
"Anthony E. Greene" <[email protected]> Fri, 14 Jun 2019 16:20:26 -0400
| Newsgroups | gmane.comp.db.postgresql.novice |
|---|---|
| Message-ID | <[email protected]> |
On 13-Jun-2019/14:19 +0200, Bzzzz <[email protected]> wrote: >On Thu, 13 Jun 2019 20:05:55 +0800 >Cravan <[email protected]> wrote: > >> Hi all, > >Hi Cravan, > >first things first : do you _really_ (I mean really, really, really) >*need* to use columns names with capital letters ? >'cos this is the kinda thing that can easily turn to troubles >comparing to put all names in lowercase. > Cravan, I use Perl, not Python, so your experience may differ. But I've been using PostgreSQL for a few years and found that life is simpler if you consistently use lowercase identifiers (e.g. table and column names). It reduces the potential for quoting problems when troubleshooting. -- Anthony E. Greene <mailto:[email protected]>