> On Jul 11, 2022, at 6:46 PM, Igor Korot wrote:
>
> Hi,
>
>> On Mon, Jul 11, 2022 at 7:56 AM Rob Sargent wrote:
>>
>>> On 7/11/22 06:31, Mladen Gogala wrote:
>>> On 7/10/22 22:52, Rob Sargent wrote:
Are you alone or on a team?
>
> No, this is my personal project.
>
> Thank you.
>
Hi,
On Mon, Jul 11, 2022 at 7:56 AM Rob Sargent wrote:
>
> On 7/11/22 06:31, Mladen Gogala wrote:
> > On 7/10/22 22:52, Rob Sargent wrote:
> >> Are you alone or on a team?
No, this is my personal project.
Thank you.
> >
> > What are your pronouns?
> >
> This did make me chuckle, but no I am ju
On 7/11/22 06:31, Mladen Gogala wrote:
On 7/10/22 22:52, Rob Sargent wrote:
Are you alone or on a team?
What are your pronouns?
This did make me chuckle, but no I am just asking whether or not the OP
is currently part of a team.
On 7/10/22 22:52, Rob Sargent wrote:
Are you alone or on a team?
What are your pronouns?
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
On 10 Jul 2022, at 17:40, Igor Korot wrote:
Hi,
Is there a query I can execute that will give me CREATE TABLE()
command
used to create a table?
Thank you.
I am using the following query for that:
```sql
select
a.attname,
a.attnum,
a.attnotnull,
pg_catalog.fo
Do it properly. Make it part of your coding infrastructure so it’s available in
the next environment. You’ll thank yourself
How should I do that?
Thank you.
I don't know what build system you are using. How do get to a running
programme? Are you alone or on a team? The instruction above o
Hi,
On Sun, Jul 10, 2022 at 8:14 PM Mladen Gogala wrote:
>
> On 7/10/22 21:13, Igor Korot wrote:
>
> How should I do that?
>
> Thank you.
>
> Oh boy! I give up.
Does he mean I need to make it as a GitHub module?
Can I even do that given that you use GitLab and my project is on GitHub?
Thank you
On 7/10/22 21:13, Igor Korot wrote:
How should I do that?
Thank you.
Oh boy! I give up.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
Hi,
On Sun, Jul 10, 2022 at 8:09 PM Rob Sargent wrote:
>
>
>
> > On Jul 10, 2022, at 6:16 PM, Igor Korot wrote:
> >
> > Hi,
> >
> >> On Sun, Jul 10, 2022 at 7:02 PM Mladen Gogala
> >> wrote:
> >>
> >> On 7/10/22 17:00, Igor Korot wrote:
> >>
> >> I understand.
> >> The Problem is that I need
On 7/10/22 20:15, Igor Korot wrote:
I understand.
The question here - does this "extension'' is a part of standard
PostgreSQL install?
And if not - can I copy and paste that code in my program?
Thank you.
Of course this function is not a part of the standard install. If it was
a part of the
> On Jul 10, 2022, at 6:16 PM, Igor Korot wrote:
>
> Hi,
>
>> On Sun, Jul 10, 2022 at 7:02 PM Mladen Gogala
>> wrote:
>>
>> On 7/10/22 17:00, Igor Korot wrote:
>>
>> I understand.
>> The Problem is that I need to put this inside the C/ODBC interface for
>> my project.
>>
>> I'm sure it
Hi,
On Sun, Jul 10, 2022 at 7:02 PM Mladen Gogala wrote:
>
> On 7/10/22 17:00, Igor Korot wrote:
>
> I understand.
> The Problem is that I need to put this inside the C/ODBC interface for
> my project.
>
> I'm sure it is not a problem when people are working out of psql or
> writing some scripts,
On 7/10/22 20:02, Mladen Gogala wrote:
This "extension" is nothing PL/PGSQL source code
This "extension" is nothing _*but*_ PL/PGSQL source code
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
On 7/10/22 17:00, Igor Korot wrote:
I understand.
The Problem is that I need to put this inside the C/ODBC interface for
my project.
I'm sure it is not a problem when people are working out of psql or
writing some scripts,
but for me it is painful to go and try to recreate it.
Now, I'm not sure
Hi,
On Sun, Jul 10, 2022 at 2:27 PM Mladen Gogala wrote:
>
> On 7/10/22 12:47, Igor Korot wrote:
>
> So there is no "query" per se?
> Also how do I pass the table name?
>
> Thank you.
>
> You can create one from the catalog tables. Personally, I would use
> INFORMATION_SCHEMA to avoid pg_class a
On 7/10/22 12:47, Igor Korot wrote:
So there is no "query" per se?
Also how do I pass the table name?
Thank you.
You can create one from the catalog tables. Personally, I would use
INFORMATION_SCHEMA to avoid pg_class and pg_attribute. However, there is
an extension which does that for you.
Hi,
On Sun, Jul 10, 2022 at 12:47 PM Ray O'Donnell wrote:
>
> On 10/07/2022 17:47, Igor Korot wrote:
> > Hi, Michael,
> >
> > On Sun, Jul 10, 2022 at 11:13 AM Michael Nolan wrote:
> >>
> >>
> >>
> >> On Sun, Jul 10, 2022 at 10:28 AM Igor Korot wrote:
> >>>
> >>> Hi,
> >>> Is there a query I can
On 7/10/22 13:57, Michael Nolan wrote:
I do not know those other tools, but there should be documentation for
them, as there is in the man page for how to process just one table
using pg_dump. You can pipe the output of pg_dump directly to psql,
but I find that's seldom useful.
--
Mike Nolan
I do not know those other tools, but there should be documentation for
them, as there is in the man page for how to process just one table using
pg_dump. You can pipe the output of pg_dump directly to psql, but I find
that's seldom useful.
--
Mike Nolan
On 10/07/2022 17:47, Igor Korot wrote:
Hi, Michael,
On Sun, Jul 10, 2022 at 11:13 AM Michael Nolan wrote:
On Sun, Jul 10, 2022 at 10:28 AM Igor Korot wrote:
Hi,
Is there a query I can execute that will give me CREATE TABLE() command
used to create a table?
So there is no "query" per se
Hi,
On Sun, Jul 10, 2022 at 11:47 AM Igor Korot wrote:
>
> Hi, Michael,
>
> On Sun, Jul 10, 2022 at 11:13 AM Michael Nolan wrote:
> >
> >
> >
> > On Sun, Jul 10, 2022 at 10:28 AM Igor Korot wrote:
> >>
> >> Hi,
> >> Is there a query I can execute that will give me CREATE TABLE() command
> >> us
Hi, Michael,
On Sun, Jul 10, 2022 at 11:13 AM Michael Nolan wrote:
>
>
>
> On Sun, Jul 10, 2022 at 10:28 AM Igor Korot wrote:
>>
>> Hi,
>> Is there a query I can execute that will give me CREATE TABLE() command
>> used to create a table?
So there is no "query" per se?
Also how do I pass the tab
On Sun, Jul 10, 2022 at 10:28 AM Igor Korot wrote:
> Hi,
> Is there a query I can execute that will give me CREATE TABLE() command
> used to create a table?
>
> Thank you.
>
Use pg_dump --schema-only
--
Mike Nolan
Hi,
Is there a query I can execute that will give me CREATE TABLE() command
used to create a table?
Thank you.
24 matches
Mail list logo
