There is also INFORMATION_SCHEMA which is SQL standard and extremely easy
to use.
On Fri, Jan 14, 2022, 1:08 PM Thomas Boussekey
wrote:
>
>
> Le ven. 14 janv. 2022 à 12:04, Ray O'Donnell a écrit :
>
>> On 14/01/2022 10:39, Flaviu2 wrote:
>> > I work on a project that use Postgre SQL, and I have
On 14/01/2022 12:51, Flaviu2 wrote:
Yes, I ran
*\c mydb1*
but I didn't see any SQL script underhood :(
Ah, OK. As I understand it, connecting to a database isn't something you
can do in SQL: it's a function of the client, and how you do it depends
on the client. - So in psql, it's a command
Yes, I ran
\c mydb1
but I didn't see any SQL script underhood :(
On Friday, January 14, 2022, 02:45:52 PM GMT+2, Ray O'Donnell
wrote:
On 14/01/2022 12:42, Flaviu2 wrote:
> Yes, I started psql with -E, and now I see the SQL underhood. Thank you.
>
> Now I need to find how to get and ho
On 14/01/2022 12:42, Flaviu2 wrote:
Yes, I started psql with -E, and now I see the SQL underhood. Thank you.
Now I need to find how to get and how to select a specific database, I
have no experience in Postgre SQL.
Well, connecting from the command line with psql, you just specify it:
psql
Yes, I started psql with -E, and now I see the SQL underhood. Thank you.
Now I need to find how to get and how to select a specific database, I have no
experience in Postgre SQL.On Friday, January 14, 2022, 01:04:47 PM GMT+2,
Ray O'Donnell wrote:
On 14/01/2022 10:39, Flaviu2 wrote:
> I
Hi,
On Fri, Jan 14, 2022 at 12:19:28PM +, Flaviu2 wrote:
> Thanks a lot.
> Maybe I am not far from a solving solution. So, if I create a database, lets
> say (SQL script):
> CREATE database mydb3;
> How can I create a table under mydb3 ? Because, if I run:
> SELECT relname FROM pg_class WHER
Thanks a lot.
Maybe I am not far from a solving solution. So, if I create a database, lets
say (SQL script):
CREATE database mydb3;
How can I create a table under mydb3 ? Because, if I run:
SELECT relname FROM pg_class WHERE relkind = 'r';
Got me all tables, but I don't know the database under w
Le ven. 14 janv. 2022 à 12:04, Ray O'Donnell a écrit :
> On 14/01/2022 10:39, Flaviu2 wrote:
> > I work on a project that use Postgre SQL, and I have 0 experience in
> > this regard. I hope to get help here. I need two SQL scripts for Postgre:
> >
> > 1. Get all databases, which I aquired already
On 14/01/2022 10:39, Flaviu2 wrote:
I work on a project that use Postgre SQL, and I have 0 experience in
this regard. I hope to get help here. I need two SQL scripts for Postgre:
1. Get all databases, which I aquired already:
*SELECT datname FROM pg_database WHERE datistemplate = false*
This
I work on a project that use Postgre SQL, and I have 0 experience in this
regard. I hope to get help here. I need two SQL scripts for Postgre:
1. Get all databases, which I aquired already:
SELECT datname FROM pg_database WHERE datistemplate = false
This one is functional, it's ok.
2. Now, I need
10 matches
Mail list logo
