Pinned

1. Retorna uma coluna com suas foreign ... Retorna uma coluna com suas foreign keys <POSTGRESQL>

   1

   SELECT 

   2

     TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME

   3

   FROM

   4

     INFORMATION_SCHEMA.KEY_COLUMN_USAGE

   5

   WHERE

2. select all columns minus one <POSTGR... select all columns minus one <POSTGRESQL>

   1

   //select all columns from table minus one column;

   2

   //work like describe

   3

   //use this to create function to select all columns with values from table, minus one column

   4

   //like this: (select *-'column_name' from table_name)

   5

3. Ddate Ddate Public

   Discordian data

   C