Re: a very naive question about table names in Postgres

2021-12-31 Thread Paul Jungwirth
On 12/31/21 12:27 PM, Martin Mueller wrote: I know that on my Mac the tables are  kept in the  data directory /Users/martinmueller/Library/Application Support/Postgres/var-13.  If I go there I see that internally the tables have numbers.  Somewhere in the system there must be a table that maps

Re: a very naive question about table names in Postgres

2021-12-31 Thread Josef Šimánek
pá 31. 12. 2021 v 21:28 odesílatel Martin Mueller napsal: > > I have a very naïve question and don’t know where tp look for the answer. I > use Postgres via AquaData Studio as a giant spreadsheet. I create tables and > give them names. I see the table names and know how to manipulate them

Re: a very naive question about table names in Postgres

2021-12-31 Thread Karsten Hilbert
Am Fri, Dec 31, 2021 at 08:27:59PM + schrieb Martin Mueller: > I much prefer Postgres to Mysql for a variety of reasons, > but mostly for its elegant string functions. But in Mysql it > seems to be much easier to keep track of tables. May I ask for the context of "keep track of tables" ?

Re: a very naive question about table names in Postgres

2021-12-31 Thread Craig McIlwee
> > I know that on my Mac the tables are kept in the data directory >> /Users/martinmueller/Library/Application Support/Postgres/var-13. If I go >> there I see that internally the tables have numbers. Somewhere in the >> system there must be a table that maps the name I gave to table X to the

Re: a very naive question about table names in Postgres

2021-12-31 Thread Gavin Flower
On 1/01/22 09:27, Martin Mueller wrote: I have a very naïve question and don’t know where tp  look for the answer.  I use Postgres via AquaData Studio as a giant spreadsheet.  I create tables and give them names. I see the table names  and know how to manipulate them with simple SQL queries.

Re: a very naive question about table names in Postgres

2021-12-31 Thread Craig McIlwee
I know that on my Mac the tables are kept in the data directory > /Users/martinmueller/Library/Application Support/Postgres/var-13. If I go > there I see that internally the tables have numbers. Somewhere in the > system there must be a table that maps the name I gave to table X to the >

a very naive question about table names in Postgres

2021-12-31 Thread Martin Mueller
I have a very naïve question and don’t know where tp look for the answer. I use Postgres via AquaData Studio as a giant spreadsheet. I create tables and give them names. I see the table names and know how to manipulate them with simple SQL queries. I know that on my Mac the tables are

Re: create query with date values

2021-12-31 Thread David G. Johnston
On Friday, December 31, 2021, ourdiaspora wrote: > Recipients, > > How to create a query such that when a date value is entered, the date may > be associated with the result of another query. > > The scenario is that a date value is entered (the plan is these dates > should be a separate table),

Re: create query with date values

2021-12-31 Thread Ron
On 12/31/21 7:12 AM, ourdiaspora wrote: Recipients, How to create a query such that when a date value is entered, the date may be associated with the result of another query. The scenario is that a date value is entered (the plan is these dates should be a separate table), then a query

create query with date values

2021-12-31 Thread ourdiaspora
Recipients, How to create a query such that when a date value is entered, the date may be associated with the result of another query. The scenario is that a date value is entered (the plan is these dates should be a separate table), then a query result is joined with the date value. Please

Re: csv copy error

2021-12-31 Thread ourdiaspora
On Thursday, December 30th, 2021 at 7:30 AM, Guillaume Lelarge wrote: > Hi, > > Le mer. 29 déc. 2021 à 22:08, ourdiaspora a > écrit : > > > > > \copy exampletable from '/local/path/to/examplefile.csv'; > > > > You should tell the CSV command you're using a CSV file. By default, COPY >