Search Postgresql Archives

PostgreSQL general set of Questions.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sunday, August 8, 2021, A Z <poweruserm@xxxxxxxxxxx> wrote:
2) How may I get PostgreSQL to output the create table statement(s) for one or more tables inside one database, without issuing instructions via the command line, but only inside a database login, as a query or pl/sql?  If not possible, what can you do at the command line, outside
of PostgreSQL?

Asked and answered
 

3) I know that I can use COPY to import or export one database table between it and a *.csv file. Can I use it to do this with multiple TABLES and *.csv files specified in one COPY COMMAND, or not?

Read the docs, if it doesn’t say you can, you can’t.
 

4) In the absence of OS command line instructions, is there an internal PostgreSQL way, via COPY or another function for example, to backup an entire database, with all it's create table statements and all insert statements, and any other associated objects as well, in one hit?
Or is this ill-advised?

Asked and answered
 

5) When setting up communication to remote databases on remote machines, I need to use the OPTIONS() function. It seems to require as its first function parameter, the schema of the table (the second parameter) that it wants to access. Can I supply a null schema, and still be able to reference the remote table, or must I also make use of IMPORT FOREIGN SCHEMA?

Asked and answered
 

6) How may I access, via a query, the log for the details of a normal table, or similar?

Asked and answered.
 

7) I have found that the native trigonometry functions, namely the radians versions, do produce error results around key trigonometry input values. I have discovered that these errors persist, even if I cast the input parameter away from DOUBLE PRECISION and into DECIMAL. I would like to know if there are any freely available scripts out there that include Arbitrary Precision mathematical functions support that calls on DECIMAL and not on DOUBLE PRECISION, that do not produce any error values or amounts around key inputs? Could someone refer me to a website that has a script that is such?

I suggest starting a dedicated thread for this demonstrating the perceived problem, maybe we can fix it or explain why it happens.

If you want to discuss any of the other questions in more depth reply to the original thread, quote the replies you did get, and ask related questions.

David J.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux